Forum Discussion
Conditional Formatting...yet another problem I can't solve
not sure if it is the order of the rules, the use or non use of the "stop if true" or what... but the formatting is not working the way i need it to. In the attached screenshot, I have highlighted that 2 rows are not showing the "blue" formatting the way it appears in the other rows... additionally the "green" formatting is not appearing at all... but if i change the order of the rules, the "green" formatting appears and some of the "blue" disappears
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.
3 Replies
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.
