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

B

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.
 
J

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
 
T

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
 
B

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?
 

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

Top