Using formula's to color cell's

[Johnny Levy]

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 - After all dates have passes in any row, the entire row should turn grey.

Is this possible?

Many thanks in advance!

 

[Douglas J. Steele]

This newsgroup is for qu estions about Access, the database product that's
part of Office Professional.

Your question would best be reposted to a newsgroup related to Excel.

 

[Johnny Levy]

Oh, I thought I did post in Excel's group... sry will move it now
--
Johnny Levy
Field Service Technician
Boston Pizza International

This newsgroup is for qu estions about Access, the database product that's
part of Office Professional.

Your question would best be reposted to a newsgroup related to Excel.