Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

Apply this rule to the entire range you want to look in:


Where A1 is the top-left cell of the range and Row 1 is the first row.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.