Conditional formatting rules aren't working

Hi sbair123 

conditional formatting rules can be tricky (and frustrating, sometimes).

If you have multiple rules that are applied to the same cell range, the order of the rules is important. The first match wins.

Example: Although cell A5 is empty, it is shown in green and not in yellow, because the green rule comes first. As the green one says, if cell content < today, this is a match (empty is < than todays date).

In this example, the rules work as expected, because the yellow rule matches before the green one will fire:

So maybe you just need to rearrange the sort order of your rules.

The other option is the check box "Stop if True". If different rules would apply different types of formatting (lets say one rule changes the font color, the other rule changes the fill color), both rules would be applied, because they change different formatting options.

If you want to avoid this, you can stop at the rule where you put the checkbox.