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?think maybe i was rambling maybe this will help. In picture 5 I added two more rows, same date of start, same date of end. but you can see the formatting in the cells is not the same. one row does not have flesh (start date) and the other does not have red (missing data)
