Conditional formatting of blank cell based on date in adjacent cell

[eabaker64]

Hi. I am having an issue with conditional formatting. I have a date in P9. Q9 is blank. I would like Q9 to display yellow fill if the date in P9 is within 14 days. If it is over 14 days, I would like the fill in Q9 to show red. I have conditional formatting as such that applies to =$Q$9: Formula: =AND(Q9="",TODAY()>P9) with red fill; =AND(Q9="",(TODAY()+14)P9) with yellow fill. In the conditional formatting rules manager, I have the red fill first and the yellow fill second. However, even when the date in P9 is within 5 days of today, it still shows as red, as does any other dates entered in P9. If I switch them around to where the yellow rule is first, every date entered in P9, even if it is 3 months old, shows as yellow. What am I doing wrong? Thanks in advance.

 

[Joe4]

Try this:

Proof:

 

[eabaker64]

Try this:

View attachment 115350

Proof:

View attachment 115351

That works perfectly. Thank you so much, you just saved me so much time and aggravation!

 

[Joe4]

You are welcome.
Glad I was able to help!