Oct 19 2023 02:03 AM
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
Oct 19 2023 02:06 AM - edited Oct 19 2023 02:06 AM
=AND(TODAY()>[cell with predefined date],A1="")
Assuming your cell is B1 and the cell to the left is A1.