Can Excel automaticly help me

[Kim]

I have following problem.

I have created my own worksheet. I use it for controlling work progress and
deadlines on different projects.

My question is: can i program Excel to automaticly give me a notice when the
date for an deadline approces.

 

[Mike H]

Kim,

There is more than 1 way but a solution most favoured is to change the
colour of a cell using conditional formating as the date in that cell
approaches. Try this:-

Select the cell with your due date in (A1 in this case) and then
Format|Conditional format
Select formula is and paste this in
=TODAY()-A1<=5
Select a colour (say red) and click add
Select formula is and paste this in
=TODAY()-A1<=10
Select a colour (say amber) click add
Select formula is and paste this in
=TODAY()-A1<=15
Select a colour (say Green) click add

!5 days before your due date the cell turns green and then amber at 10 days
and red at 5.

Mike

 

[Gord Dibben]

You could use Conditional Formatting to color a cell when a date is being
neared.

=A1<TODAY()+7 would turn the cell a color when the deadline is less than one
week away.


Gord Dibben MS Excel MVP