Forum Discussion
Help with conditional formatting (dates)
Hello! I want to set a conditional formatting rule where if the date in cell A is "past due" and cell B is empty, then cell B is highlighted. I also tried to do if the date in cell A is "past...
let's say you want to apply the conditional formatting to B2:B100 then highlight those cell and go to 'create new rule' then select 'use custom formula' then in the formula box use a formula like:
=($A2<TODAY() )*ISBLANK($B2)
then set the formatting you want in cells B2:B100
for the other option select Cells A2:A100 (for example) and use the exact same formula but set the formatting (text color) you want.
=($A2<TODAY() )*ISBLANK($B2)
then set the formatting you want in cells B2:B100
for the other option select Cells A2:A100 (for example) and use the exact same formula but set the formatting (text color) you want.