Alerting for a due date

[GE]

I posted this earlier in the week but unfortunately the fixes proposed did not work.

I have a cell with a due date which i want to alert me by changing colour when the date is reached.
EG. date due is 1/1/03,so i want the cell to turn red on that date. If possible i would also like a pre alert of say 5 days before this time by turning green.

Thanks

 

[Jack in the UK]

Hi

These many ways to do this maybe the simplist way would be to look at the conditional fromatting of the cell or range of cells, format to RED fill if greater than the date you want,


HTH

Kind regards
Jack

 

[GE]

Jack, i am a bit of a novice at this, could you give me a little more info.

Thanks

 

[Jack in the UK]

Do you have email ill email a wbook with its set up if that helps

Jack

 

[GE]

Thanks.

please use gary_edge@hotmail.com

 

[GE]

Thanks.

please use gary_edge@hotmail.com

 

[GE]

Thanks.

please use gary_edge@hotmail.com

 

[GE]

Thanks.

please use gary_edge@hotmail.com

 

[Jack in the UK]

Hi

WkBk sent the work book to you, all i ask is you report back on the board how thinks went

These an image on sheet 2 to show beter and copy that.

Jack

 

[GE]

Works a treat, thank you very much