View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason Bartup Jason Bartup is offline
external usenet poster
 
Posts: 1
Default conditional formats for cells

I wish for certain cell to be say green if date entered is within one year of
todays date. Then change to red if date is over one year of todays date. I
know this is possible but cant get the right formular