Today’s document editing market is enormous, so finding a suitable solution satisfying your needs and your price-quality expectations can take time and effort. There’s no need to waste time browsing the web looking for a universal yet straightforward-to-use editor to Negate arrow in Xls file. DocHub is here at your disposal whenever you need it.
DocHub is a world-recognized online document editor trusted by millions. It can satisfy almost any user’s demand and meets all required security and compliance certifications to ensure your data is safe while changing your Xls file. Considering its rich and intuitive interface offered at a reasonable price, DocHub is one of the best choices out there for enhanced document management.
DocHub provides many other capabilities for effective document editing. For instance, you can transform your form into a re-usable template after editing or create a template from scratch. Discover all of DocHub’s capabilities now!
so what im going to talk about here is how we can use the icon set in conditional formatting the green and red arrows here on this green yellow red choice and how we can change it to show a green arrow when the number is positive and a red arrow when the number is negative and so ive gone ahead with i got four numbers here and got two one positive and one negative over here and ive just applied these right out of the box and you can see that on this negative one down here we have a green arrow and so we have to figure out whats going on so were going to manage rules edit rules and we can see that uh its not applying this based on just if its positive green if its negative red its applying this based on a thirds so if its in the upper third its going to give it a green arrow if its in the middle third its going to give it a yellow arrow and then if its in the bottom third its going to give it a red arrow so we have 33 and then 67 percent here and so its designed to have