Have you ever struggled with editing your Xls 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 Vary arrow in Xls files quickly and anytime needed.
DocHub will surprise you with what it offers. It has robust functionality to make whatever updates you want to your paperwork. And its interface is so intuitive that the whole process from start to finish will take you only a few clicks.
Once you finish adjusting and sharing, you can save your updated Xls document on your device or to the cloud as it is or with an Audit Trail that contains all alterations applied. Also, you can save your paperwork in its original version or transform it into a multi-use template - accomplish any document management task from anywhere with DocHub. Sign up today!
welcome to excel metric number 1204 if you want to download this workbook and follow along click on the link below the video in this video we have a column of errors and we need an icon to show up if we go from day 1 to day 2 or any two days and we go down we want it to show an up arrow if we go from one day to the next and the errors go up we need a down red arrow if theres no change sideways yellow now in order to use the icon conditional formatting were going to need a number in the cell to indicate the three different sets so Im going to choose 0 1 and -1 now theres a couple ways we can do this if we want this rule right here - 1 for green arrow 0 for no chains 1 for red we could simply go hey Im going to take the later day - the earlier day now notice this is going down and its a - double click and send it down what we really want is - 1 0 1 so guess what Im going to steal a trick from mr. Excel all the way back in one of our first dual six or seven years ago hey we know