How do I find highest number in a row and change color?

P

pamstolen

Which formula would I use to find the highest number in a row, and change the
color of that cell to red? Is that an array formula?
 
J

Jason Morin

Assuming row 1:

1. Select the row and go to Format > Conditional
Formatting.
2. Select "Formula Is" and put:

=MAX(1:1)=A$1

3. Press the "Format" button and format as desired.

HTH
Jason
Atlanta, GA
 
P

pamstolen

Thanks. That worked great. I don't suppose there is a way to do the same
thing for the second highest. Thanks for your help.
 

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

Findiing highest and lowest in rows and columns 3
Highlight Highest Amount 2
Finding location (or start cell) of highest consecutive values 3
Changing row background from external program 0
Index/Match Functions to Return Concatenated Response 4
Trying to find additional ranges outside of min, max, and average 2
Tracked changes by multiple people modified to one 0
Match table shading (color) to Visio color/Transparency 1

Top