Conditional Formatting to highlight highest number in column

[robertguy]

Hi, is it possible to use Condition Formatting to highlight the highest number in column i.e. colour the highest number ‘green’ in cells A2 to A20

Any help would be gratefully appreciated


Rob

N.B. Excel version 2003

[arthurbr]

Select the range a2:a20 select format - conditional formatting - select " Formula is" in the drop down box and enter =RANK(A2;$A$2:$A$20)=1
select the formatting you need

[Richard Buttrey]

Hi Rob,

Using the Formula Is option

Please Login or Register  to view this content.

Rgds

[Marcol]

Try

Conditional formatting

Formula is:=
=$A2=MAX($A$2:$A$20)

Applies to:=
=$A$2:$A$20

Format...... > Fill Green

Hope this helps

[robertguy]

Arthurbr / Richard / Marcol

Many thanks for your responses they work excellently

Thanks again

Rob