Forum Discussion
Change a cell appearance if another cell is blank when TODAY is 3 days or less prior to despatch
Hello,
Please can I have some help here?
A2 Date Required
B2 Name
C2 Paid? (Blank cell until they pay)
I want to use conditional format to change cell B2 (black fill, white text) if C2 is still blank when TODAY is 3 full days or less away from the date in A2.
To clarify, A2 is 10/01/2022. On 7/01/2022 the name cell changes appearance if C2 is still blank.
Thank you for any assistance.
GarthI Create a conditional formatting rule like this:
=AND(ISBLANK(C2),A2-TODAY()<=3)
and apply to the $B$2:$B$nnn, where nnn is the last row number you want to apply this rule to. Have attached a file with an example.
2 Replies
GarthI Create a conditional formatting rule like this:
=AND(ISBLANK(C2),A2-TODAY()<=3)
and apply to the $B$2:$B$nnn, where nnn is the last row number you want to apply this rule to. Have attached a file with an example.
Many thanks for your help. This is perfect.
