Using Excel to autopopulate color..
 

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

Using Excel to autopopulate color..
 

In addition to the above information.. is there a way to populate dates to a
calender from a specific Column?
--
Johnny Levy
Field Service Technician
Boston Pizza International


"Johnny Levy" wrote:

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

Using Excel to autopopulate color..
 

Can anyone help me out here?
--
Johnny Levy
Field Service Technician
Boston Pizza International


"Johnny Levy" wrote:

In addition to the above information.. is there a way to populate dates to a
calender from a specific Column?
--
Johnny Levy
Field Service Technician
Boston Pizza International


"Johnny Levy" wrote:

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

Using Excel to autopopulate color..
 

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

On Mon, 29 Sep 2008 13:28:02 -0700, Johnny Levy
wrote:

Can anyone help me out here?