Applying Max Conditonal Formatting to an entire row when condition

[SunshineinFt.Myers]

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?

 

[T. Valko]

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

 

[Shane Devenshire]

Hi,

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