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?

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?

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?