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)

  • @Tim done. check your sheet. I used =IF(AND(C3 < TODAY(), C3<>"", A4="", C3<>0), 1). also if you dont want SUM to show 0 when there are no data to sum, use: =if(B3<>"",sum(A3,B3),) – MARK MY ANSWER Feb 14 at 16:12
  • 1
    Thanks!! You are awesome!! I also found if I change your =if(B3<>..... to =if(A3<>...... it eliminates the "0's" and works great. Thanks again!! – Tim 12 hours ago

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.