Forum Discussion
Solved
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 highlig...
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.
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.