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,
Keith

 

[Wigi]

This makes 3 conditions, no?

Also counting the basic formatting of a cell, you have up to 4 formatting
possibilities. If you want, you have a few more if you color the cell
contents with Cell formatting.

If you need to go even beyond that, use VBA or use Excel 2007.