Question Locked

Excel 2003 - Selecting a greater number from a list of numbers

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I was wondering how this can be done
Starting from Column A Row 1 say I have a list of numbers 1,3,9,7. How can i highlight that Column A Row 3 is the correct answer. I want this highligted in any bold colour say Red for example.
Use the formula =max(A1:A4) only returns the value which 9 but i want the cell itself to be highlighted.
One way could be conditional formatting but I don't know which formula to use.
Any help would be much appreciated.
Thanks

3 replies

by locolobo

There might be a better way to do this but in cell A21 enter =max(A1:A4).

Highlight cells A1:A4 go to format -> conditional formatting.

Condition 1: Cell Value is equal to $A$21, now set your format.

Good luck it worked for me.

by probro

Very smart Lobo. Many Thanks. It worked.

This discussion is closed to new replies.