Conditional formatting blank cell

[Billvh]

I have a question on conditional formatting that I was hoping I could get some help with.

Amount​	Due Date​	Paid Date​
$2,147.54​	1/21/21​	12/22/20​
$47.00​	1/26/21​	​

I have three columns.

Column A is the amount due

Column B is the due date

Column C is the date that the amount was paid

I would like to set conditional formatting for column C to do the following:

• If a cell in column C is empty within 14-days of the due date I would like for it to turn yellow
• If a cell in column C is empty within 7-days of the due date I would like for it to turn red

Thanks for your time and your help.

 

[Zot]

I figured it out.

I changed the formatting on the cell to date, but it didn't update until I went back in and change the date itself. After that everything worked fine.

I really appreciate all of the help!

Good to hear it worked. Thanks for the update