Formatting a cell to change color as an alert for subscription renewals

Hi All. I am busy creating a very simple spreadsheet in which I am tracking the registration renewal date for subscribers to an online database. I would very much like for the cell that contains their original registration date, to firstly change colour when 10 months has passed to alert my team to send out a reminder to renew the subscription. Then, I would like to have the cell change colour again when a year has passed; instructing my team to suspend the account. In short, could you please show me what conditional formatting I would need on the cell in question to do this?

Suppose the original registration dates start in cell D2 and continue down that column. Select all those dates from D2 down, then click on Conditional Formatting | New Rule | Use a formula... , then enter this formula in the dialogue box:

=AND(TODAY()-D2>=300,TODAY()-D2<365)

(an approximation for 10 months - 300 days), then click on the Format button | Fill tab and choose your colour (e.g. yellow), then click on OK twice to exit the dialogue box.

Repeat for your second condition and use this formula:

=TODAY()-D2>=365

and choose a different colour (e.g. red).

Excel will automatically adjust the cell references to suit the cells that you had originally selected.

Hope this helps.

Pete