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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing entire row based on 1 MAX cell value (Conditional Formatt 2
Applying Conditional Formatting to a Max number in range 5
Conditional formatting Max to a entire row A1:D1 with E1 being Ma 2
Using icon sets with relative references 0
Conditional Formating copying (Max Min) 3
Conditional formatting 2
have an entire row populate with a link when the data in a cell ch 1
Merging cells and formats 8

Back
Top