Forum Discussion
Solved
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 ...
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))
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)
It might help if you explained in detail what each of the conditional formatting rules is supposed to do. I've just been trying to edit them blindly without any idea of what their purpose is.
- Thanks for being patient.... The yellow rules just defines the current week. The flesh colored defines the week the service starts and the blue defines the week the service ends. In each week of service, the employee is to hyperlink to a PDF report. The red rule notes which weeks do not have an "X" in them which indicates that a PDF has been linked
- thank you.... that worked!!