Highlight 5 largest numbers in a long list

[Manosh]

Hi all,

I have a Score column that runs into many entries.


Is there a way to highlight the top 5 scores on the list in different
colours.


Conditional format permits me to highlight the three largest only (yes
another gripe on this much needed excel feature!)


Any help is appreciated in advance!!


Regards
Manosh

[Don Guillett]

See ans in MISC. Pls only post in ONE group.

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Manosh" <manoshde@gmail.com> wrote in message
news:1145109352.215626.172940@e56g2000cwe.googlegroups.com...
> Hi all,
>
> I have a Score column that runs into many entries.
>
>
> Is there a way to highlight the top 5 scores on the list in different
> colours.
>
>
> Conditional format permits me to highlight the three largest only (yes
> another gripe on this much needed excel feature!)
>
>
> Any help is appreciated in advance!!
>
>
> Regards
> Manosh
>