K
khaji00
i am in need of a formula that will compare the current date with th
date in another cell. if the date in the other cell is past th
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 i
possible can i tell excel to turn the cell Yellow if that date HAS NO
passed but is approaching (say within 30 days)? Can someone pleas
tell me 1. if any of this is possible, and 2. what formulas i need t
accomplish this. Thanks
date in another cell. if the date in the other cell is past th
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 i
possible can i tell excel to turn the cell Yellow if that date HAS NO
passed but is approaching (say within 30 days)? Can someone pleas
tell me 1. if any of this is possible, and 2. what formulas i need t
accomplish this. Thanks