Have you ever struggled with modifying your Spreadsheet document while on the go? Well, DocHub has an excellent solution for that! Access this cloud editor from any internet-connected device. It allows users to Include light in Spreadsheet files quickly and whenever needed.
DocHub will surprise you with what it provides you with. It has powerful capabilities to make whatever updates you want to your paperwork. And its interface is so simple-to-use that the entire process from beginning to end will take you only a few clicks.
When you finish modifying and sharing, you can save your updated Spreadsheet document on your device or to the cloud as it is or with an Audit Trail that includes all modifications applied. Also, you can save your paperwork in its original version or transform it into a multi-use template - complete any document management task from anyplace with DocHub. Subscribe today!
hello everyone into this video Im going to show you how to create traffic light in Excel so lets get started so before creating our traffic like we want to make sure that the traffic light will satisfy all the conditions from this table so if our sales amount is anything more than 30,000 our traffic light will be green if our sales amount is anything in between 15,000 to 15,000 our traffic light will be yellow and if our sales amount is less than 15,000 our traffic light will be red next highlight all the cells under this column and then go to conditional formatting click on new rule and change the format style to icon set so this is what we want to display on our table click on show icon only and then you need to change the type to number you have to be very careful with the middle section here because we want to make sure all the logical expression satisfy the conditions from this table so when the sales amount is more than 30000 counterfeit light should be green so this is incorre