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