Have you ever struggled with editing your Excel document while on the go? Well, DocHub comes with an excellent solution for that! Access this online editor from any internet-connected device. It enables users to Faint brand in Excel files rapidly and anytime needed.
DocHub will surprise you with what it provides you with. It has powerful capabilities to make any changes you want to your forms. And its interface is so straightforward that the entire process from start to finish will take you only a few clicks.
As soon as you finish adjusting and sharing, you can save your updated Excel 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 initial 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 897 if you want to download this workbook click on the link below the video in this video here we have a data set and anytime the brand column contains PCC thats our criteria here we want to highlight the whole row if we change the criteria here to WF we want to highlight WF alright conditional formatting a row were going to use a logical formula true/false formula and mixed cell references Im going to build my formula down here and copy it down and over as if I was going to do it in the actual cells because conditional formatting with a formula you have to put a true/false formula into a dialog box but its as if its actually in the cells because each cell in this row needs to ask the question in the brand column is there PCC in this cell I want to go down to the next row this all the cells here need to ask the question is whole food markets or is PCC in this particular case in this column alright lets build our formula down here Im going to say eq