locate highest value in Col

[Martindelica]

hi there, I have a column of percentages, like below:

35
67
93
24
34
93
85
67
29

I need Excel to highlight the highest one. In my example then Excel would highlight both of the 93's. Is there a formula for this that I could use in a conditional format?

Kindest regards,
Martin.

[oldchippy]

Hi,

Sorry about that select A1 and apply CF to it, then use the paintbrush icon to apply to the other cells

=A1=MAX($A$1:$A$10)

[VBA Noob]

Try

=$A1=MAX($A:$A)

VBA Noob

[Martindelica]

Sweet thanks I got it to work. Since I have a formula already in A1 I couldnt paint the cells. So I painted them before selecting the CF and it worked using your formulas...Thanks again.

[oldchippy]

Glad to hear it worked for you - thanks for the feedback