highlight the cells you want to conditional format
select conditional format
select, if cell value is greater than or equal to,
then select the cells you want to compare to
then select the condition
then click add
and do it again but this time select less than, and select the
condition you want then press ok

the one cell should have the formula =today()


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=543972