Can Excel automaticly help me

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
Back
Top