Excel 2007 : Conditional Formatting a Date Table?

**oldchippy** · 04-19-2009, 05:32 AM

Hi,

On the ribbon Home tab, go to Conditional Formatting, Highlight Cell Rules, Between, enter

=TODAY()

and

=EDATE(TODAY(),1)

select your shading

**oldchippy** · 04-19-2009, 05:46 AM

Hi,

Forgot to mention, select your range of cells first, then do the CF

THORmx · 04-19-2009, 11:47 PM

Thanks Chippy! Can you explain what each function in the EDATE things means?

Also, anyway to do it on like (monthly, 2 weeks, or 56 days?) thanks again so much for your help!

**oldchippy** · 04-20-2009, 03:00 AM

Hi,

Well as you can see there are not many parts to EDATE, but basically the first part is the start date and as you wanted it to be dynamic then we can use TODAY(). The second number being the number of months, either before or after the start date. EDATE is exactly a number of months from the start date, so 15/02/2009 to 15/03/2009 is a different number of days to 15/04/2009 to 15/05/2009.

If you wanted to do 2 weeks or 56 days, then you could use instead of EDATE

=TODAY()

and

=TODAY()+14

being 14 days or 56 days