Forum Discussion
Help with a conditional formula with multiple conditions
I want to apply a conditional formula that highlights A1 if the date in A1 has passed, AND B1 is blank, AND C1 is NOT blank. Can anyone help with how to do this? Thanks!
Select A1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(A1<>"",A1<TODAY(),B1="",C1<>"")
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.