Need Macro Date Help not based on Today's Date

**Sally_Shell** · 05-18-2011, 07:29 PM

Please help - been struggling for awhile. I need cell F16 to change RED when cell D16 (a date) has been 14 days past due. When it is 7 days before due I need it to be Amber color. I would prefer a macro if possible.

Also I would like it to reference cells accordingly. So then cell F17 would change to RED when cell D17 (a date entered) has been 14 days past due. Thank you for your help!!

In the image I need the GREEN cell to be RED after 14 days from the date in the Cell with 21-Oct-10 in it

**Richard Buttrey** · 05-18-2011, 08:10 PM

Hi,

Any particular reason why you need a macro? A standard conditional format will do what you want.

Always use standard Excel functionality where possible since it's always quicker than a macro and usually simpler and quicker to create.

Regards

**p24leclerc** · 05-18-2011, 08:38 PM

here is a simple macro that does what you want, I think. The only question I have is about your title stating "not based on today's date". So it is based on what date then? Where is it?

Look at the macro, and I'm sure you'll be able to change the NOW() funtion with the proper reference to the reference date you need.

regards
Pierre

**Sally_Shell** · 05-19-2011, 12:21 AM

Hello and thank you for replying. I am sorry I was not clear. It is based on a date entered into a Cell. It is all based on tracking samples. I want cell F16 to change RED when cell D16 (10-10-2010) has been 14 days past due. Then cell F17 to change RED when cell D17 (11-15-2010) has been 14 days past due and so...I dont understand what conditional format to use? And how to apply it to all columns so that it references the the correct row? THANK YOU AGAIN!! I just thought a macro would be easier??