Help with formula

P

Pat

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
 
D

David Biddulph

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?
 
Top