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 ...

CS2.xlsx236 KB

excel

Formulas and Functions

office 365

HansVogelaar
Jul 13, 2021
HRGuru55

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))
CS2.xlsx236 KB

HRGuru55

Copper Contributor

Jul 15, 2021

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

HansVogelaar

MVP

Jul 15, 2021

HRGuru55

Thank you. Try this for red:

=AND($F3>0,P$2<=TODAY(),P$2<$N3,P$2>$F3,P3="")