Oops.

Use:
=P8=MAX($P$8:$P$25)

Sorry about that.

REJesser wrote:

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.

"Dave Peterson" wrote:

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)



REJesser wrote:

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.

"Pete_UK" wrote:

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

On May 14, 2:21 pm, REJesser
wrote:
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.



--

Dave Peterson


--

Dave Peterson