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

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

1 Answer 1

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.