View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek Derek is offline
external usenet poster
 
Posts: 51
Default conditional format date range

Ok so I have a sheet containing dates in cells B2 through B171. I want the
cells to highlight based on a date that is in cell F4. I want it to
hightlight all the dates from the date in F4 + 180 days. That way when I
change the date in F4 it will change the highlighted dates in B2:B171.
Please Help !!! Thanks