Applying Max Conditonal Formatting to an entire row when condition
 

I want to change the entire row color when one cell is the max out of the
range. Ex: A1, B1, C1, with the the Max being in cell D1?

Applying Max Conditonal Formatting to an entire row when condition
 

Try it like this...

Select the range of cells A1:D1
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(A1<"",A1=MAX($A1:$D1))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote in
message ...
I want to change the entire row color when one cell is the max out of the
range. Ex: A1, B1, C1, with the the Max being in cell D1?

Applying Max Conditonal Formatting to an entire row when condition
 

Hi,

Try not to post the same question more than once (a day?). See your other
post for another solution.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"SunshineinFt.Myers" wrote:

I want to change the entire row color when one cell is the max out of the
range. Ex: A1, B1, C1, with the the Max being in cell D1?