software

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).

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

=$E$1-C1gt;30where 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

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