Change a cell appearance if another cell is blank when TODAY is 3 days or less prior to despatch

[GarthI]

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.

[#2 · Accepted solution]

@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.

[#3]

@Riny_van_Eekelen 

Many thanks for your help.  This is perfect.