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.