Conditional Formatting - formula

Copper Contributor

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

 

1 Reply

@Bao_Van 

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

 

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