Forum Discussion
Conditional Formatting
Can anyone help... The screenshot shows the conditional formatting rules that I have created. The first (yellow) works with no problem. The third (flesh) works with no problem. The other two (red & blue) only work some of the time. I believe all cells are formatted the same. Workbook is enclosed.
ie... red does not work in Row 3 (columns W - AO),4 (in columns AL-AO),5(only in column AP), 6 (in columns AL & AM), 7 (in columns Q & AF), 9 (in columns AF, AG, AK,AL,AM), 10 (in columns AM-AP), 11 (In columns AM-AP) and 12 (in columns AL - AP).
Blue does not work in Row 9 and wont work in Rows 10-12 if I change date back to early July.
The rule for blue has $N3>P$2. This should be $N3>=P$2.
You can simplify it to =AND($N3>=P$2,$N3<Q$2,P$2<TODAY()+5)
I think you need the following formula for the rule for red:
=AND($F3>0,P$2<=TODAY(),P$2>=$F3,TODAY()>$N2,ISBLANK(P3))
9 Replies
The rule for blue has $N3>P$2. This should be $N3>=P$2.
You can simplify it to =AND($N3>=P$2,$N3<Q$2,P$2<TODAY()+5)
I think you need the following formula for the rule for red:
=AND($F3>0,P$2<=TODAY(),P$2>=$F3,TODAY()>$N2,ISBLANK(P3))
Hans,
Thank you, i made a little change so the red would not show up later than the blue and everything seemed to be working perfectly. Added a lot more data to test.... AND.. the formatting started getting wonky. See attached. At Row 41 the Red formatting stopped working..... unless I change the date in column N to a date that is prior to today. then it works in the next row. ( i have illustrated in screenshots 1 and 2 what happens). any ideas of what is going on?
