I have a checklists created. When a due date is near, how do I set up a cell
to change into a color to inform me. For example, I have a list of license
with various due dates that must be updated every 4 years. As the due dates
nears or for licenses that are due now, I want the cell to change to red.
Can any one help?

Your description is a little thin. In general you can use conditional
formatting with a formula comparing the date in the cell to the current date.
If that is less than some threshold then colour the cell.
--
HTH...

Jim Thomlinson


"amievaj" wrote:

I have a checklists created. When a due date is near, how do I set up a cell
to change into a color to inform me. For example, I have a list of license
with various due dates that must be updated every 4 years. As the due dates
nears or for licenses that are due now, I want the cell to change to red.
Can any one help?

Conditional Formatting.

Assuming due date in A1

Formula is: =A1<TODAY()+8

Format to red pattern.

A1 will turn red when within 7 days of today.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 08:38:01 -0700, amievaj
wrote:

I have a checklists created. When a due date is near, how do I set up a cell
to change into a color to inform me. For example, I have a list of license
with various due dates that must be updated every 4 years. As the due dates
nears or for licenses that are due now, I want the cell to change to red.
Can any one help?