Hello all,
I want to get a conditional format to work with deadlines I would love to know what I am doing wrong as it seems simple and I used this nearly 5 years ago, I appreciate your time,
Test line
Input date > input date completed, Deadline formula is 2 days, but ignores blank cell.
I have tried
=AND(C2-E2)<2
=C2-E2<2
==AND(C2-E2)<2
=if(C2-E2)<2 (i get a error on this one)
all 3 show red, but won't turn green when the dates are within the 2 days deadline, and they also show red when the date in E is not inputted.
Bookmarks