With DocHub, you can easily revise light in excel from anywhere. Enjoy capabilities like drag and drop fields, editable text, images, and comments. You can collect eSignatures securely, add an extra layer of defense with an Encrypted Folder, and work together with teammates in real-time through your DocHub account. Make adjustments to your excel files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents folder of your account. Manage, email, print out, or convert your file into a reusable template. With so many powerful features, it’s easy to enjoy smooth document editing and managing with DocHub.
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 letamp;#39;s 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 let