Conditional Formatting - the date is between date A and date B

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nikki - 13 Sep 2007 05:10 GMT

Hi,

I have a spreadsheet that is for tracking work. I would like to have
conditional formatting so that if the date in column E is between todays date
and 4 weeks away then make it blue, if it is a date that is after 4 weeks
away then make it yellow but if it is in the past make it red.

Can this be done with conditional formatting or does it need vba? Also it
would be nice if the whole row changes colour even if just the condition is
on the date which is in column E - but if that can't be done then just the
cell is fine.

Thanks

Reply to this Message

Peo Sjoblom - 13 Sep 2007 05:37 GMT

Assume the dates start in E2, select all dates with E2 as the active date
use formula is

=E2<TODAY()

click format button and select red font or pattern, click OK, now click add
and use

=E2>TODAY()+28

click format button and select yellow font or pattern

click add

and use

=AND(E2>+TODAY(),E2<=TODAY()+28)

repeat and select blue font/pattern then click OK twice

You might want to change the boundaries if you want exclude/include a date
or so

(meaning changing >= to > etc)

Signature

Regards,

Peo Sjoblom

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

Nikki - 17 Sep 2007 02:22 GMT

Hi,

I don't quite understand sorry. Which parts am I supposed to highligt? I
had a list of dates with the first date in E2 and the last date in E10. I
highlighted the list and then did the conditioning formatting. Nothing has
changed tho so I must have done something wrong.

Any ideas?

Nikki

> Assume the dates start in E2, select all dates with E2 as the active date
> use formula is
[quoted text clipped - 36 lines]
> >
> > Thanks

Reply to this Message

Rate this thread: