Hello everyone,
Been introduced to this forum by a friend of mine who says it is the place to go when faced with the difficulties of being useless at excel but want to learn how to make it do what you want.
This is what I need certain cells in a data range to do.
I send out correspondence to customers setting a reply by date. At the moment I check my dates daily and when I'm approximately two days away from the reply by date I highlight those dates in yellow indicating they are running close to the date. When the date is today I change the field to orange to show items I need to work on. When it is two days past the reply date I highlight them red indicating reminders need to be issued.
I need to set a conditional formatting formula which caters for this and no matter whether I try the TODAY or NOW function I just cant seem to get it to work. PLEASE HELP!
Heres an example:
I issue correspondence for a customer requesting contact by 10/05/2013.
On the 08/05/2013 (two days prior to this) I would like the cell colour to change to yellow
On the 10/05/2013 (day the reply date was set for) I would like the cell colour to change to orange
On the 12/05/2013 I want the cell colour to change red
However, is there any way to set a control whereas if a reply is received I can indicate this on the form so no colours are activated. I suppose I can manually remove the conditional formatting for the cell if there is no easy way to do that as otherwise all dates will eventually turn and stay red.
Please help if you can.
Warmest Regards
Bookmarks