Highlight largest value in column

[loobner]

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

[rwgrietveld]

Condition Format

Select Column M (e.g.)
Use formula =$M1=MAX(M:M) as conditional format

[ChemistB]

This will work too; Select Col M
from Create New Rule>Format only Cells that Contain

Select "Equal to" and enter =MAX(M:M)

[loobner]

I've tried both ways and I still can't get it to work

[ChemistB]

Can you attach a workbook in which you used one of the methods?

[loobner]

Used in Column B

[zbor]

It's working but in last row you have value 304 wich is =SUM(B2:B1048575). Delete it.

[teylyn]

Your formula in B5 is

=$B6=MAX(B:B)

so it will highlight B5 if B6 is the max. Follow Ricardo's or ChemistB's instructions to make it work.

[teylyn]

It's working but in last row you have value 304 wich is =SUM(B2:B1048575). Delete it.

zbor, that was cut off when I opened the file in XL03 , So, yep, there may be another problem on top of the wrong row reference!!

[zbor]

On the other hand I didn't check referencing

[ChemistB]

Okay, first, you have a value of 304 in the last row of column B.

Select Column B and from Conditional formatting> Clear Rules> Clear from Selected cells

If you are going to use rwgrietveld's formula, you need to set it =B1, not B2 as you did. Hope that helps.

[loobner]

Thank you all so much. PROBLEM SOLVED.

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save