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

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

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

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

I put the date entry in cell B2 and in D2 i put =TODAY(), this gives today's
date in D2. Select cell B2, select Format|Conditional Formatting and set the
first box to 'Formula Is' in the entry box write =$B$2<($D$2+14), then click
format and select the format you want when the date is within 14 days of
today or the date has passed.

"Pat" wrote:

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

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