Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? . |
#3
|
|||
|
|||
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? . |
#4
|
|||
|
|||
=LARGE(1:1,rank)=A$1 where rank 1, 2, 3, ...
Ola Sandstrom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|