Highlight 5 largest numbers in a long list

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlighting the 5 Largest Numbers in a list 24
adding largest numbers 2
Is this possible with excel? 9
Adding sums in rows and columns and colouring cells with conditions 4
Formula (or code) return the largest number of duplicates in a list. 16
grouping highlighted rows 3
Highlight Largest Amount in a row 2
conditional format 9

Top