Solved Needs help with Conditional Formatting

Microsoft Excel for mac 2011 - macintosh
June 21, 2017 at 17:28:44
Specs: Mac OSX 10.8.4
A B C D

2 2 3648 913
2 3 5472 2737
2 4 7296 4561
2 5 9120 6385
3 2 2432 303
3 3 3648 913
3 4 4864 2129
3 5 6080 3345
4 2 1824 911
4 3 2736 1 < This cell is highlighted since it has the min. value
4 4 3648 913
4 5 4560 1825
5 2 1459 1276
5 3 2189 546
5 4 2918 183
5 5 3648 913

In Col. D, it will detect the minimum value (the "1" in Col. D) and highlights with conditional formatting. How can I make Col. A & Col. B (in this case, it's the 4 & 3) of the same row highlight simultaneously with conditional formatting?
Sorry can't seem to be able to add more spaces between the columns. TIA.

message edited by uhjb


See More: Needs help with Conditional Formatting

Reply ↓  Report •

#1
June 21, 2017 at 18:46:21
Try this:

Conditional Formatting 2007

1) Select your cell or range of cells, in your example A1:D16
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:

=$D1=MIN($D$1:$D$16)

6) Click on the Format button
7) Select the Fill Tab
8) Select a pretty color
9) Click OK
10) Click OK

See how that works for you.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
June 22, 2017 at 00:49:15
Hi Mike, thanks for your quick response to my problem. I have tested it, and is working more or less like I’m hoping for. Thank you.

Reply ↓  Report •

#3
June 22, 2017 at 03:17:07
✔ Best Answer
is working more or less like I’m hoping for.

What is wrong?

I just reread your original request.
Is the problem you do not want the entire Row highlighted,
you only want columns A, B, & D highlighted?

If that is the problem, then try this:

On the Ribbon, select Conditional Formatting
Select Manage Rules
In the drop down box at the top labeled Show formatting rules for:
Select This Worksheet
In the Applies To box delete the contents and enter the cell selection of:

=$A$1:$B$16,$D$1:$D$16

Click OK

This will apply the formatting to Columns A, B & D only.

If that is not the problem, please explain in detail what is wrong.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

Related Solutions

#4
June 22, 2017 at 17:19:28
That's exactly what's wrong with it. But I've already tweaked it a bit and it's now working as I expected. Regardless, thanks for your further suggestions. I do appreciate all your help.

Reply ↓  Report •

Ask Question