Setting up the traffic light system within Excel

[Branchman]

I want to setup a spreadsheet with a list of mandatory courses that should be completed every 1 to 3 years and I would like to setup a traffic light system against each course listed so that:• When the course has been completed the cell for that particular course is 'Green'; • When the course is within one month of its time expiry, the cell turns 'Amber';• When the course has gone over its time expiry, thjen the cell turns 'Red';Is anyone able to provide some guidance on how I can achieve my goal.Many thanks in advance.

 

[DRSteele]

Welcome to the forum.

A picture says a thousand words, and a video a million. Check out these and other videos from ExcelIFun on youtube to get a basic understanding of Conditional Formatting. Then let us know if you still need help.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/watch?v=45QYIUBVSMY
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/watch?v=-wjGFCl93zQ[/FONT]

[/FONT]