Hello,

My brain is fried. Attached is the current document I am working on.

I would like the document to do the following:
-Turn red if the required date is past due
-Turn orange if the required date is in the next 5 days

-Create a summary page of the following, from each sheet:
Material Submittals Due within 5 Days
Material Approvals Past Due
Delivery to Site within 5 Days
Delivery to Sire Past Due

Thank so so so much in advance!

Attached Files

Procurement Log.xlsx (28.2 KB, 3 views)