Applying Max Conditonal Formatting to an entire row when condition

  • Thread starter Thread starter SunshineinFt.Myers
  • Start date Start date
S

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?
 
Try it like this...

Select the range of cells A1:D1
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
 
Hi,

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