Applying Max Conditonal Formatting to an entire row when condition

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?
 
T

T. Valko

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
 
S

Shane Devenshire

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

Top