Traffic Light system to identify a due date HELP

In Column L I need it to change color from Green to Amber to Red when it is due to be renewed I need the amber to come on when it is 21 days away and red when it is 10 days away the date it was done is in column k hope this makes sense

can anyone help

thanks

MarcussTest Planner (1).xlsx

See http://www.xldynamic.com/source/xld.CF.html#due

Sorry think I am being a bit thick I have tried this but I am using excel 2007 and the conditional formatting doe not show condition 1 and 2 not sure what to do will this work with this version of excel

thanks for your help so far

Marcuss

I believe this will work in Excel 2007 as well. You need a rule for each condition (one rule for red, one for yellow and one for green). The one I would use for this is "Format only cells that contain..." and in the formula box add your conditions .

Take a look at:

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

When pulling up the Conditional Format menu, choose Manage Rules and then add a rule for each condition as outlined in the post by Bob Phillips.

You can also take a look at http://www.homeandlearn.co.uk/excel2...l2007s6p2.html for more help - this page has screen shots.

Cheers,

Cliff Watson

Many thanks for this

Perfect