View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Help with formula

This is what I need: I put a date in cell B3-B25, it's the date someone
started the job. The date in cell C3-C25 are when the personnel are due to
leave. I want the cells C3-C25 to be highlighted red when the personnel are
2 weeks from leaving.

Name Date in Date out

John Smith 3 Dec 06 4 May 06
--
Pat