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