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 as...
Hi Lisa,
Please try this
=AND(B2>1,B2<TODAY()+3)
It returns FALSE if no date in B2
Hi Lisa,
Please try this
=AND(B2>1,B2<TODAY()+3)
It returns FALSE if no date in B2