Issues with conditional formatting. Formulas not working/not using the right formula

Hello all

I'm sure this has been answered somewhere in this forum and I've scoured other forums but nothing seems to be working for me.

I'm trying to use conditional formatting to highlight a cell when I hit a certain date range but the formulas I've found aren't working, or I'm not using them correctly.

At my job, we have paperwork that needs to be updated every 3 months for each individual. I have a column that has the most recent date of the paperwork and another column with the expiry date of the paperwork. What I'm trying to do is to have the cell for the expiry date be green when it's new, so date of the document <=60 days from completion, yellow when it's >=61 days up to 89 days, and then red when it hits the expiry date (90 days) and beyond. All the formulas I'm finding use TODAY but I need it to pull from the document completion date and the expiry date.


So for example, if the document was completed on 01/01/2015 the expiry date would be 04/01/2015. I would want the cell to be green from 01/01/2015 until 03/01/2015, then yellow from 03/02/2015 to 03/31/2015, then red on 04/01/2015 and remain red until I enter in a new date. (obviously, give or take some days, not every month is 30 days!)

I hope what I'm asking for makes sense. What I've tried so far hasn't been working. Either all the cells will just be red (whether or not they're expired) or the cells won't change colour at all (even though I have formatted a colour).

If anyone could help, that would be great.

Thanks.

I've attached an idea of what the spreadsheet looks. I'm trying to have the cells (F column) change colour based on time left between column F and column E. I looked at the webpage and that's what I had been using. The cells aren't changing colours properly and if I change the dates then the cells go blank entirely. I'm sure I'm doing something incorrectly but I can't figure out what.