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.

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



On 23 Mar, 23:00, Browny wrote:
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.

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.

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.
--
David Biddulph

"Jarek Kujawa" wrote in message
...
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



On 23 Mar, 23:00, Browny wrote:
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.

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" wrote:

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.
--
David Biddulph

"Jarek Kujawa" wrote in message
...
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



On 23 Mar, 23:00, Browny wrote:
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.

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)
--
David Biddulph

"Browny" wrote in message
...
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" wrote:

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.
--
David Biddulph

"Jarek Kujawa" wrote in message
...
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



On 23 Mar, 23:00, Browny wrote:
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.