I have a question on conditional formatting that I was hoping I could get some help with.
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:
Thanks for your time and your help.
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.