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.