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
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