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

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.

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

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.

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

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.

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

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.

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

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.

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

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.