Forum Discussion
Conditional Formatting...yet another problem I can't solve
Rule formula in addition to other conditions checks if the day (R1) is less than Actual End (P3). For the mentioned rows Actual End is blank, which is converting to zero using in formula. Thus that always returns FALSE, thus no colors.
Conditional formatting checks rules one by one top to down. If it finds rule which triggers the formatting, it ignores the rest of the rules.
Your Blue rule has subset of conditions which Green rule has. Thus if Blue is before Green the latest never be checked.
Please check in attached.
- Any suggestions as to why formatting is not working in rows 5 & 8
Rule formula in addition to other conditions checks if the day (R1) is less than Actual End (P3). For the mentioned rows Actual End is blank, which is converting to zero using in formula. Thus that always returns FALSE, thus no colors.
