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

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?

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

-----Original Message-----
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?
.

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.

"Jason Morin" wrote:

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

-----Original Message-----
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?
.

=LARGE(1:1,rank)=A$1 where rank 1, 2, 3, ...

Ola Sandstrom