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

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)


--

Regards,

Peo Sjoblom

"Nikki" <(E-Mail Removed)> wrote in message
news:CB799836-2A40-4ACD-B26C-(E-Mail Removed)...
> 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
>
>

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

"Peo Sjoblom" wrote:

> 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)
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Nikki" <(E-Mail Removed)> wrote in message
> news:CB799836-2A40-4ACD-B26C-(E-Mail Removed)...
> > 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
> >
> >
>
>
>