Using Excel to autopopulate color..

[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 - 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]

In addition to the above information.. is there a way to populate dates to a
calender from a specific Column?

 

[Johnny Levy]

Can anyone help me out here?

 

[Gord Dibben]

For the coloring and uncoloring of cells, see help on Conditional
Formatting.

For the Calendar populating, we would need more detail, see help on "linking
cells"


Gord Dibben MS Excel MVP