Formatting based on date ranges

  • Thread starter Thread starter Rodney
  • Start date Start date
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
 
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.
 
Back
Top