I have done this but all the cells are coming up yellow. Unless I have entered them wrong. I have entered the following dates just to check the conditional formatting.

A1: 3/4/14
A2: 4/4/14
A3: 5/4/14
A4: 6/4/14

With conditional Formatting:

cell value less than =today()+365-90 yellow
cell value less than =today()+365-60 amber
cell value less than =today()+365+30 red
cell value greater than =today()+91 green

This is correct?