Hi All

I need some help I have a training spreadsheet that has a list of
trainees names across the top and down the side the course name and the
validity period. Within the spreadsheet I have the dates that the
person recieved their training. What I am wondering is can I get a
function to look up the validity period eg 2 yrs and check it against
the date and change the colour to red when it has expired, orange when
2 months away from expiry and green when current? Please help

Thanks