2

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 1

5

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.

3
  • I added a little bit to my question which might invalidate your answer, sorry.
    – DForck42
    Jan 2, 2012 at 21:28
  • Try it. It works for me.
    – Excellll
    Jan 2, 2012 at 21:54
  • If you have a header, then of course, you would use MAX(2:2).
    – Alex
    Nov 5, 2012 at 14:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .