select the entire column that you have the dates in - assume col C

in conditional formatting:

format backround to red and in condition select forumla is and type
in:
=AND(C1<"",DATE(YEAR(C1),MONTH(C1),DAY(C1))=DATE( YEAR(NOW()),MONTH(NOW()),DAY(NOW())))

create another conditional format with background yellow, select
forumla is and type in:
=AND(C1<"",DATE(YEAR(C1),MONTH(C1),DAY(C1))DATE( YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-14,DATE(YEAR(C1),MONTH(C1),DAY(C1))<DATE(YEAR(NOW( )),MONTH(NOW()),DAY(NOW()))+14)

hth


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=374145