View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dmorlando dmorlando is offline
external usenet poster
 
Posts: 5
Default Conditional Formating for dates beyond 30, 60, 90 to be high light

My spread sheet has sales prospects names, numbers, titles, etc. I also have
a column titled "last date of contact" with dates in the cells. I want the
dates in these cells to change color or the cell to be high lighted when that
date goes beyond 30, 60 or 90 days.
Thanks