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.