View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lou825 Lou825 is offline
external usenet poster
 
Posts: 8
Default Can a cell be changed on a certain date

I have Excel 2003 and I want a cell to change colors when the date i put in
the cell is within six months of todays date. Is this possible?
if A1 has 12NOV08 and A2 has 12NOV09 how can I get A2 to change to red when
its six months from todays date