Multiple Color Conditions
Conditions are evaluated from top to bottom.
Assume you have the following conditions defined:
Change color if value is greater than 30
Change color if value is greater than 100
In this example, if the value of the cell was greater than 100, the first condition of "greater than 30" would change the cell's color since its first in the list of conditions to be evaluated. The "greater than 100" condition would never trigger in this example since "greater than 30" will always trigger the color change first. To ensure that both conditions trigger a color change so that you get the desired alerting behavior you want, you have to list the conditions in this order:
Alert if value is greater than 100
Alert if value is greater than 30
This will guarantee that a cell value over 100 will fall in the "greater than 100" condition and cell values between 30 and 100 will be triggered by the "greater than 30" condition.
Comment