I've got several rows and columns of numbers. For each row I want to highlight the record that is the highest number or tied for the highest number in that row. I know how to do this for one row, but how can I easily apply this across multiple rows?
1 Answer
Apply this rule to the entire range you want to look in:
=A1=MAX(1:1)
Where A1 is the top-left cell of the range and Row 1 is the first row.
-
I added a little bit to my question which might invalidate your answer, sorry.– DForck42Jan 2, 2012 at 21:28
-
-