Formatting based on date ranges

[Rodney]

Hi Guys,

I'm now looking to set some conditional formatting on my worksheet which
will highlight the cell green if the date is greater than or equal to todays
date(e.g. 19/07/08 or 27/07/08). I also, however, want the cell to go blue if
its within 7 days of todays date (e.g. 17/07/08), and red if its 7 days or
more old (e.g. 07/07/08).

Is it possible to do this with conditional formatting as i appreciate that
you can only set three rules?

Cheers,
Rodney

 

[Wigi]

See your other post.

Please post it only once.

 

[M Kan]

Here's an example I tested. The order of your conditional tests is
important. The graphic I've linked to shows the test cells and the
conditional format dialog box

http://www.kan.org/tips/images/conditional_format_date.jpg