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 A11
Goto the menu Format>Conditional 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" <(E-Mail Removed)> wrote in
message news:B3FFC23A-F355-4CD7-B213-(E-Mail Removed)...
>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?