View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SoggyCashew SoggyCashew is offline
external usenet poster
 
Posts: 8
Default Conditional format calculate 6 months

Hello, I cant figure out how to do this. I have a date in a cell, lets say
its 10/5/9 and I want that box to stay red untill 6 months have past. so when
its 4/6/10 then the box wont be red anymore.
--
Thanks,
Chad