View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Help with formula

Format/ Conditional Formatting:
Cell Value is/ less than/ =TODAY()+14
Choose the appropriate format

I assume that in general the column B values will be *before* the column C
values?
--
David Biddulph

"Pat" wrote in message
...
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