CONDITIONAL FORMATTING (COLOR)

[Matt Cicioni]

IS there any way to use conditional formatting to change
the color of a cell that has the maximum value of a range
of cells?

For example:

Say I have 4 cells with 4 different values:

10 34 45 18

I want to change the color of the cell with the highest
value. I want it to be bright green. I also want it to
change if the values change and another cell becomes the
high number in the range. Is this possible with
Conditional Formatting? Please help.

 

[Paul Corrado]

Matt,

Yes you can do this with conditional formatting

Data|Conditional Formatting

Select "Formula Is" from the drop down list and add the formula

=MAX($A$1:$A$4)=A1

which assumes your values are in A1:A4 and A1 is the active cell (the one
that is not colored in your highlighted range)

Then select the Format option and use the Patterns tab to set the background
color.

HTH

PC

 

[Bob Phillips]

Matt,

Squire is.

Assume the cells are A1:A4

Select A1:A4
In CF, change Condition1 to Formula Is
Input the formula =MAX($A$1:$A$4)
Select the Format button, Pattern tab and pick a colour

 

[Tim Otero]

Hi Matt,

If your range is A1:A10 the formula would be:

=A1=MAX($A$1:$A$10)

tim