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.