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