I am using Excel 2003.
I want to use a conditional format to identify by a different color when a
date is 90, 180 and 360 days from todays date.

I have two rows of data. The top row contains a room number and the bottom
row contains a date.

m701 m702 m703 m704
12/1/04 7/1/03 10/5/05 12/1/05


I want the top row of data(room number) to change from green, to yellow, to
red as the date in the bottom row varies from todays date by 90,180,360 days.