Hi all,
Can anyone advise how best to setup the conditional formatting for the following scenario please?


Column A has list of users
Column B has the date they last did training X
Column C has the date they last did training Y
etc etc

Training X is due for renewal 2years from the date it was last done
Training Y is due for renewal 7 months from the date it was last done
etc etc

At specified time periods from when the training was done, I want the colour of the box to change to visually highlight that it is either a) still far off b)coming up to renewal c) due very soon d)overdue (so green, amber, red, dark red)

I cant work out what rule I need put in the conditional formatting though.

Anyone help please? Using Office 2007 if it makes any difference.

Thanks,

mads

Put in a "colour scale " conditional formatting with
minimum set as a formula ( =today()-720) )
maximum set as a formula ( =today() )

Stephen

[Edited on 24/1/13 by stevebubs]

The above is for office 2010; 2007 may be slightly different...

Walked to work laptop (office 2007)

Exactly the same. U2U me your email and I'll send you an example if you want.

S

Thanks Stephen. What if I want three or four distinct colours rather than a scale though?

You can 'stack' conditional formats, so instead of scales you have solid colour for each range. Just keep repeating the process.