Forum Discussion
Solved
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 ...
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.
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.