assume the dates starts in C1 going down, select all cells from C1 do
formatconditional formatting
formula is

=$E$1-C130


where E1 would be the cell where you put the date

click format and select red pattern

add a second condition and use

=$E$1-C1=30

select red pattern, press OK twice

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"MWad22368" wrote in message
...
I am using Excel 2003. I want to have Excel highlight the cell 30 days
prior
to the date that I put into the cell. Example 4/30/06...I want excel to
highlight the cell yellow 30 days prior to that date. Also...I want excel
to
highlight the cell red when the date has past (expired).