Changing color of dates to show how close they are to expiring

[C.j.]

I have a list of need by dates. I want to create a formula that will turn the date blue when it is 14 days out and red when it is 7 days out. I attached a sample

[Blake 7]

This sounds more like an instruction than a request for help but scrolling through your previous posts I can see that you never take the time to mark threads as solved or even bother to acknowledge someones help so the tone doesn't surprise me.