Forum Discussion

Bao_Van's avatar
Bao_Van
Copper Contributor
Oct 19, 2023

Conditional Formatting - formula

Hi all.

 

I am looking for a formula for conditional formatting:

I want a cell to be highlighted, if today's date has passed a pre-defined date AND the neighbouring cell on the left is blank.

If the cell at the left contains something, and today's date has exceeded the 'due date', it should not be highlighted.

Is that possible? Thank you in advance.

Best regards

 

  • BA_Max's avatar
    BA_Max
    Iron Contributor

    Bao_Van 

    =AND(TODAY()>[cell with predefined date],A1="")

     

    Assuming your cell is B1 and the cell to the left is A1.

Share