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
Paragraph numbering in Word 1
Adding sums in rows and columns and colouring cells with conditions 4
Copying rows values on one sheet to part of a formula in a column onanother sheet. 2
Automatically highlight certain data. 1
Numbered list problem 6
Anyone a conditional formatting guru? 8
sorting and highlighting in a list 2

Top