Forum Discussion
Conditional Formatting
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))
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?