Re: Creating a formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Pat" <Pat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C2675B3F-1AEC-4270-86F3-DBE30F2D4C92@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Something more than Conditional Formatting
    ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ... Of course, what I forgot was that you are using conditional formatting, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Calendar...
    ... Look at conditional formatting - See ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: CONDITIONAL FORMATTING- DATES
    ... (replace somewhere in email address with gmail if mailing direct) ... I am setting up conditional formatting to change the interior colour ...
    (microsoft.public.excel.programming)
  • Re: Something more than Conditional Formatting
    ... Of course, what I forgot was that you are using conditional formatting, ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: A macro to color the cells according to the values existing in a c
    ... Use conditional formatting ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ...
    (microsoft.public.excel.programming)