Excel 2007:

HomeStylesConditional FormattingTop/Bottom RulesTop 10 Items. Use the
spinner to select 1 (or enter 1) and then in the "with" box, select the
formatting of choice.

Tyro

"Browny" wrote in message
...
in a footy tiping spreadsheet, higest scores of the round is 12, 4, 8, 12
& 12
i want to highlight the cells with the highest scores 'conditional format'
and leave the lower scores plain.