Highlighting largest value in column

[loobner]

I want the largest value in a column to automatically highlight and the old high value to return to normal. Is this possible?

[teylyn]

Hi, try this

select the whole column, let's say it's column A
click Conditional Formatting on the Home Ribbon and click New Rule
select "use a formula to determine ..."
enter this formula

=max(A:A)

select a format and hit OK

adjust the column reference to suit.

hth

[teylyn]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.