Excel 2007 : Conditional Formatting a Date Table?

Hi,

Could someone please help me on Conditionally formatting a date table? I would like to make a table, and have dates that are within 1 month (for example, may be different) of the current date to turn red.

For example
system date shows 4/17/09

I'd like any date in the table that shows 5/17/09 or earlier (up to 4/17/09 of course) to turn red.

Any ideas? Thanks!!

Maybe you can post an example workbook

May be this will help?

Hi,

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

=TODAY()

and

=EDATE(TODAY(),1)

select your shading

Hi,

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

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

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save