I've searched and searched and can't find the fix to my problem. In the old Excel, this was easy. But the 2007 version seems to have a problem with this. Hopefully some of you smart folks can help. Here is what I need.

I want to put a future date in a cell. Until the conditional format takes effect, the cell should have NO fill. Between 90 and 61 days PRIOR to the date in the cell, the cell should turn green. Between 60 and 31 days prior to the date in the cell, the cell should turn yellow. And between 30 and 1 days prior to the date in the cell, the cell should turn red. I'm trying to avoid having an additional cell so the worksheet doesn't get too long with extraneous cells. I've worked all the formulas I can think of, but none of them seem to work. Please help.