Hello, I have a worksheet that cell A1 is calculated with a formula =B1+45
and it is formatted to display as a date. The date entered into cell B1 will
be displayed as 45 days ahead in A1.

I need to conditional format cell A1 to show a yellow background color if
TODAY's date is is equal to or greater than B1 plus 15 days; Yellow
background if TODAY's date is equal to B1 plus 16 days but less than B1 plus
30 days; and a Red background if TODAY's date is greater than B1+31...

I can't get the colors to change since the date in the cell A1 is always 45
days.
Basically cell A1 tells me the 45 day drop dead date and I want the cell
background color to give me visual warnings as to what stage the time is in.

Any ideas how I can make this work???