Yet another conditional formating question (Excel 2003)
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.
|