Prev: SOS! how do I run Excel without running the VBA in AUTO_OPEN?
Next: Scroll up to ?
From: Simon on 4 May 2010 11:27
Dear All,

I am looking for some help formatting cells with date entries using excel
2003.
I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen
variations on this theme in other threads, but don't seem to be able to get a
formula to work with the following;

Date entered into cell (not necessarily 'todays' date). Cell turns yellow
when 300 days have elapsed from the date entered, cell turns red when 365
days have elapsed from the date entered

(I have the cells formatted for date)

Grateful for any help. Thanks.
From: Pete_UK on 4 May 2010 12:06
You need to set up 2 conditions. First condition (default) has to be:

=(A1-TODAY())<365

and format Red. Then click Add to set up the second condition:

=(A1-TODAY())<300

and format Yellow.

The first condition has priority over the 2nd (and 3rd). This assumes
that A1 is the cell selected.

Hope this helps.

Pete

On May 4, 4:27 pm, Simon <Si...(a)discussions.microsoft.com> wrote:
> Dear All,
>
> I am looking for some help formatting cells with date entries using excel
> 2003.
> I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen
> variations on this theme in other threads, but don't seem to be able to get a
> formula to work with the following;
>
> Date entered into cell (not necessarily 'todays' date). Cell turns yellow
> when 300 days have elapsed from the date entered, cell turns red when 365
> days have elapsed from the date entered
>
> (I have the cells formatted for date)
>
> Grateful for any help. Thanks.

From: Luke M on 4 May 2010 12:13
You were very close...
First condition (red format)
=TODAY()-A1>365

Second condtion (yellow format)
=TODAY()-A1>300

Think of this as being "The distance between today and the date in A1 is
more than x days"

--
Best Regards,

Luke M
"Simon" <Simon(a)discussions.microsoft.com> wrote in message
news:C32C1451-522C-4E23-B5F5-69966D816B35(a)microsoft.com...
> Dear All,
>
> I am looking for some help formatting cells with date entries using excel
> 2003.
> I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen
> variations on this theme in other threads, but don't seem to be able to
> get a
> formula to work with the following;
>
> Date entered into cell (not necessarily 'todays' date). Cell turns yellow
> when 300 days have elapsed from the date entered, cell turns red when 365
> days have elapsed from the date entered
>
> (I have the cells formatted for date)
>
> Grateful for any help. Thanks.


 | 
Pages: 1
Prev: SOS! how do I run Excel without running the VBA in AUTO_OPEN?
Next: Scroll up to ?