Formatting based on date ranges

R

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
 
W

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.
 
Top