Formatting based on date ranges
 

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

Formatting based on date ranges
 

See your other post.

Please post it only once.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Rodney" wrote:

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

Formatting based on date ranges
 

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/condi...ormat_date.jpg

--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Rodney" wrote:

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