I seem to be having a problem with conditional formatting in Excel 2010. I have a set of date points, percentages between 1 and 100. I applied three rules in the following order,
- if greater than 75% apply formatting 1
- if greater than 80% apply formatting 2
- if greater than 85% apply formatting 3
I have not checked "Stop if true" for any of the rules. Yet only the first two rules are applied. I can change the order by promoting rule 3 to rule 1 and then all the rules are applied, but I don't see what is wrong with the current order.
A minimal working example can be found here: