Need Macro Date Help not based on Today's Date

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

Duplicate post, thread closed. Please continue in your other thread.