'conditional format' cells for the highest number in a range

[Browny]

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.

 

[Jarek Kujawa]

Excel 2003

Format->Conditional Formatting ->Formula Is: =MAX(range)

and select your format

then add 2nd condition Formula Is: <>MAX(range)
and select your format

 

[Tyro]

Excel 2007:

Home>Styles>Conditional Formatting>Top/Bottom Rules>Top 10 Items. Use the
spinner to select 1 (or enter 1) and then in the "with" box, select the
formatting of choice.

Tyro

 

[David Biddulph]

But you don't need to specify the 2nd condition. The default cell format
for the range will apply if the first condition isn't satisfied.

 

[Browny]

Thank David
i have tried the conditional format below, but when i copy it to all cells
they all display the new format. I.E 12, turns red & 8 turns red also. What
have i done wrong?

 

[David Biddulph]

Yes, well spotted. Jarek had a problem in the instructions which he gave
you. It should say either
Format->Conditional Formatting ->Cell Value Is / Equal to: =MAX(range)
or
Format->Conditional Formatting ->Formula Is: =A1=MAX(range)