Hello all, I was wondering if anyone could tell me how to color a cell
when a date nears or is the same date. Is this possible?


Thanks!
DLS



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Take a look at Conditional Formatting in XL Help.

You probably want your condition to read something like:

Formula Is =(TODAY()-5)< A1

this assumes that A1 is the cell you're conditionally formatting and
that you want the cell colored if the current date is later than 5
days prior to the value in A1. After you enter the formula, click on
Format and select a color from the Patterns tab, then click OK, OK.





In article <(E-Mail Removed)>,
dsmith7265 <(E-Mail Removed)> wrote:

> Hello all, I was wondering if anyone could tell me how to color a cell
> when a date nears or is the same date. Is this possible?

Format>conditional formatting, formula is

=AND(A1-TODAY()<5,TODAY()<=A1)

where A1 is the date, I used less than 5 days, change that to what you want

--

Regards,

Peo Sjoblom


"dsmith7265" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello all, I was wondering if anyone could tell me how to color a cell
> when a date nears or is the same date. Is this possible?
>
>
> Thanks!
> DLS
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

Try to set a formula comparing date using the conditional formatting.
bill

"dsmith7265" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello all, I was wondering if anyone could tell me how to color a cell
> when a date nears or is the same date. Is this possible?
>
>
> Thanks!
> DLS
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>