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

I have a worksheet that has dates in cells B2 through B171. I want to
highlight cells from a date that is in cell F4 + 180 days. I want to be able
to change the date in F4 and the dates in B2:B171 to highlight accordingly.
Please help. Thanks