My team has a workbook that has quite a bit of manual work involved. I am
attempting to streamline these documents. I have successfully created the
neccessary lists etc, however our tracking of dates and new information is
eluding my searches through excel information online.

We color new information Yellow, once the information has been noted we
change it to no fill.

We also have dates that require attention (colored red as deadlines
approach) or dates that have been modified (blue/cyan)

What I would like to do is use a formula for the entire workbook that will
autopopulate the colors when, for instance:

#1 - New information is added to a given cell. At a specified date/time I
would like the color to revert to 'No fill'.
#2 - When a due date is approaching and the information is
missing/unattended the corresponding cell should autopopulate "red" as a
warning
#3 - When items have been filled with yellow, but then altered, the
Cyan/blue option should color the cell in question.
#4 - After all dates have passes in any row, the entire row should turn grey.

Is this possible?

Many thanks in advance!

--
Johnny Levy
Field Service Technician
Boston Pizza International