Thanks, this formula worked perfect. Thanks for your help

"Ragdyer" wrote:

Select A1 to D1, then:
<Format <ConditionalFormat

Click Formula Is, and enter:
=AND(A20,A2+360<=TODAY())
Click "Format", and color font RED,
Then <OK,
Then <Next, for condition 2,

Click Formula Is, and enter:
=AND(A20,A2+180<=TODAY())
Click "Format", and color font Yellow,
Then <OK,
Then <Next, for condition 3,

Click Formula Is, and enter:
=AND(A20,A2+90<=TODAY())
Click "Format", and color font Green,
Then <OK, <OK.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"shane561" wrote in message
...
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.