Hi Guys;

I apologize for reaching out to you for help, this is my last resource I have been looking through the web and videos with the answer to my issue. This is the situation:

I have a table that has the following Headers
  • Date
  • Case #
  • Summary
  • Caller
  • Status

And due to our business needs we have 2 past due dates, one is for any item that has been 3 days in the table we need to send a reminder and every item after 7 days is past due and needs to be closed. So what I am trying to do is using Conditional Formatting to highlight every item that has been past due 3 days in blue and when it reaches the 7 days of past due to change to red to be closed.

Would anyone please be so kind to assist me with this situation?

Thank you very much in advance.