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 ...
excel
Formulas and Functions
BA_Max's avatar
BA_Max
Iron Contributor
Oct 19, 2023

Bao_Van 

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

 

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

Resources