Conditional Formatting

[Mark A Tilley]

I have a column of scores.

Is there any way to use conditional formatting to set the highest score to
blue, the second highest to red and the third highest to green?

Thanks in advance

Mark

 

[Peo Sjoblom]

Select the whole range, assume the range is A1:A20 for simplicity,
if you select from A1 it will be the active cell, open conditional
formatting, select formula is and

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

click the format button and select either a blue font or blue pattern, click
OK,

click add and formula is but use

=A1=LARGE($A$1:$A$20,2)

format red

click add again and formula is

=A1=LARGE($A$1:$A$20,3)

select green, click OK twice

Done

note the mix of relative and absolute referencing

You could of course use LARGE for all 3 formulas but you save some typing
using MAX for the first <g>


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Mark A Tilley]

Thank you Peo Sjoblom

Your answer was not quite what I was looking for, but it did point me in the
direction of the RANK function which was exactly what I needed.

Thanks again

Mark