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