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!