Forum Discussion
Bao_Van
Oct 19, 2023Copper Contributor
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