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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
Back
Top