I have Column C, RESPA DATE, that has a date that varies for each borrower.

I want to change the color of the cells in Column D, DISCLOSURES SENT, daily within three days of Column C until a date gets entered into the cell.
Once RESPA is triggered I have three days to send out disclosures.

I was wondering how I could format the cell to change to green on day 1, yellow on day 2 and red on my last day 3 until I enter a date then it goes back to a white cell.

  • share a copy of your sheet please
    – user0
    Apr 25, 2019 at 22:10

1 Answer 1

  • white: cell is not empty
  • green: =IF((TODAY()=$C2+1)+(TODAY()=$C2),1)
  • yellow: =IF(TODAY()=$C2+2,1)
  • red: =IF(TODAY()=$C2+3,1)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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