Yet another conditional formating question (Excel 2003)

  • Thread starter Thread starter REJesser
  • Start date Start date
R

REJesser

Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. I would like the cell with the highest incident rate to
have its background change to red. I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. Thanks in advance for any help.
 
Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete
 
Clearly I have done something incorrectly. I used the following as the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of the
cells changing color. I tried to outsmart it by using your second suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.
 
Select P8:P25
With P8 the activecell, use this
Format|conditinal formatting
Formula is: p8=max($p$8:$p$25)

Same kind of thing with the second condition (if you wanted it):
formula is: p8=large($p$8:$p$25,2)
 
Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the quotes
from appearing? Thanks.
 
What Dave gave you was a formula.
All formulas *start* with an equal sign.

Therefore, enter:

=p8=max($p$8:$p$25)


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the quotes
from appearing? Thanks.
 
And there was much rejoicing! Thanks to all of you for your assistance.

RagDyeR said:
What Dave gave you was a formula.
All formulas *start* with an equal sign.

Therefore, enter:

=p8=max($p$8:$p$25)


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the quotes
from appearing? Thanks.
Click to expand...
 
We all appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

And there was much rejoicing! Thanks to all of you for your assistance.

RagDyeR said:
What Dave gave you was a formula.
All formulas *start* with an equal sign.

Therefore, enter:

=p8=max($p$8:$p$25)


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the
quotes
from appearing? Thanks.
Click to expand...
 
Back
Top