Creating the Traffic lights in excel is very nice idea to show the Performance Indicator. We have created this traffic light by using auto shapes then connected it with the data. As soon as the value will be change, Traffic Light will be on/off accordingly.
Click here to download this excel file.
Watch step by step video tutorial to learn how to create Traffic Lights in MS Excel