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
|