i am in need of a formula that will compare the current date with the
date in another cell. if the date in the other cell is past the
current date, i want that cell to be highlighted in Red. For example,
if the date in the cell is June 10, 2005 and today's date is June 22,
2005, i want excel to turn that June 10, 2005 cell Red. Also if
possible can i tell excel to turn the cell Yellow if that date HAS NOT
passed but is approaching (say within 30 days)? Can someone please
tell me 1. if any of this is possible, and 2. what formulas i need to
accomplish this. Thanks!


--
khaji00
------------------------------------------------------------------------
khaji00's Profile: http://www.excelforum.com/member.php...o&userid=24547
View this thread: http://www.excelforum.com/showthread...hreadid=381433