Whether you are already used to dealing with excel or managing this format for the first time, editing it should not feel like a challenge. Different formats may require particular software to open and edit them properly. Yet, if you need to swiftly tack light in excel as a part of your typical process, it is best to find a document multitool that allows for all types of such operations without extra effort.
Try DocHub for sleek editing of excel and also other document formats. Our platform provides easy papers processing no matter how much or little previous experience you have. With all tools you have to work in any format, you won’t need to switch between editing windows when working with every one of your files. Effortlessly create, edit, annotate and share your documents to save time on minor editing tasks. You will just need to sign up a new DocHub account, and you can start your work immediately.
See an improvement in document processing efficiency with DocHub’s straightforward feature set. Edit any document easily and quickly, regardless of its format. Enjoy all the advantages that come from our platform’s efficiency and convenience.
[Music] hello friends welcome back my name is Priyanka Kumar and today how to create traffic lights in Microsoft Excel as you are seeing my screen I have created these three beautiful traffic lights in Microsoft Excel and these are totally dynamic and connected with these data points so if I will change the value of service level then the light will be changed and the logic of changing the traffic lights is this for we have taken three matrix here service level productivity and sales conversion and this is the performance for all of three matrix and these are the rules if my service cable is less than 50% then red light will be displayed if substa bill is 50 to 70% then yellow light will be displayed or if service level is greater than 70% then green light will be displayed and similarly for the others here the number is changed okay so lets check if I will take as 80% which is greater than 70% and that is my service level is displaying in green light and if I will change lets say 6