Conditional formatting

[Barney]

I have 16 numbers in a column. The numbers range anywhere from 0 to 350. I
want the highest number to appear in red text, the second highest in blue,
and the third highest in green. The remained will be in the default color.

Using Excel 2002 how do I setup the conditional formatting dialog?

Thanks in advance for your help.

Barney

 

[Niek Otten]

Format>
Conditional Formatting,
Formula is, =RANK(A4,$A$1:$A$4)=1 , choose a color
Add, next formula (last part "=2")
etc

 

[Dave Peterson]

Another way...

Select your range (I used A1:A16)

Format|Conditional formatting:
first condition:
Cell value is Equal to =max($a$1:$a$16)
format nicely

click add.
second condition
cell value is equal to =large($a$1:$a$16,2)
format nicely

Click add
third condition
cell value is equal to =large($a$1:$a$16,3)
format nicely

click ok

 

[Niek Otten]

Yes, easier

--
Kind regards,

Niek Otten

Another way...

Select your range (I used A1:A16)

Format|Conditional formatting:
first condition:
Cell value is Equal to =max($a$1:$a$16)
format nicely

click add.
second condition
cell value is equal to =large($a$1:$a$16,2)
format nicely

Click add
third condition
cell value is equal to =large($a$1:$a$16,3)
format nicely

click ok

 

[Barney]

Thanks Niek and Dave. Both ways work perfectly.

Best regards, Barney