This is what I need: I put a date in cell D3-D25, it's the date someone
started the job. The date in cell E3-E25 are when the personnel are due to
leave. I want the cells E3-E25 to be highlighted red when the personnel are
2 weeks from leaving. I put the formula in the cells and they all turn red;
even the ones where they don't leave until March or July.
--
Pat


"Bob Phillips" wrote:

Why not? Was it just a case of you could see the principle but not the
detail for your problem, or it just didn't see to apply at all to you?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Pat" wrote in message
...
Bob,
Thanks for the website but, it did not help.
--
Pat


"Bob Phillips" wrote:

You need conditional formatting. See
http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Pat" wrote in message
...
I need a formula that when a date is typed into a cell the box will turn
a
color when the date is within 14 days.
--
Pat