Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Not sure if I'm sharing this right but below is a link to my sheet. Cell C3 is past today so it is red. What I'm trying to do is have it go back to white when I enter the next "Last change" date in cell A4 and continue in this manner. This possible?
=IF(AND(C3 < TODAY(), C3<>"", A4=""), 1)
=IF(AND(C3 < TODAY(), C3<>"", A4="", C3<>0), 1)
Required, but never shown