Editing xls is fast and straightforward using DocHub. Skip installing software to your computer and make adjustments with our drag and drop document editor in a few fast steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust features that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and email documents for completion to other people. All of this, put together with a competing price, makes DocHub the ideal choice to take out light in xls files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the protection of your information, as we securely store them in the DocHub cloud.
hello everyone into this video Iamp;#39;m going to show you how to create traffic light in Excel so letamp;#39;s 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