Conditional formatting

B

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
 
N

Niek Otten

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

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
 
N

Niek Otten

Yes, easier

--
Kind regards,

Niek Otten

Dave Peterson said:
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
Click to expand...
 
Top