Changing color of max or min value in a column

[utoyo]

I'm not sure if there is an easier way than in VB to do this so please point me in the direction if VB isn't necessary.

I'd like to change the color (or highlight) the max value and/or the minimum value in a column in excel. For example, if you have a column with test results in it, the max value (score) might have the font color changed to green and the min value changed to red. How would I go about doing this?

Thank you in advance.

 

[AnotherHiggins]

No need for VBA. Have a look at Conditional Formatting in Excel's help file.

Let's say that your totals are in A. Then the formula to find the MAX would simply be:
[tab]=Max(A:A)
And to fine the MIN,
[tab]=Min(A:A)

Good luck and g'night! (nearly 2AM here)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.