Forum Discussion
Solved
Conditional formatting formula
I am wanting a cell to turn red 3 days prior to the date entered in the cell. I have entered the following formula but the question mark is me asking you what I should enter here. I am trying to ask 'if B2 is not empty'. Please help!!!
=AND(B2<>?,B2<TODAY()+3)
Hi Lisa,
Please try this
=AND(B2>1,B2<TODAY()+3)
It returns FALSE if no date in B2
1 Reply
Hi Lisa,
Please try this
=AND(B2>1,B2<TODAY()+3)
It returns FALSE if no date in B2