When you need to apply a minor tweak to the document, it should not take long to Enter highlight resolution. This type of basic activity does not have to demand extra education or running through manuals to understand it. Using the right document editing resource, you will not spend more time than is necessary for such a quick edit. Use DocHub to simplify your editing process whether you are a skilled user or if it’s the first time using an online editor service. This instrument will take minutes or so to learn to Enter highlight resolution. The sole thing required to get more productive with editing is a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to devote to document editing regardless of your prior experience with this kind of instruments. Create an account now and improve your efficiency immediately with DocHub!
to start things off lets head over to the formulas tab click on the define name button lets name it current row then change the refers to value to equals one were done in here so just click okay next click on the corner button to swatch the entire worksheet we need some conditional formatting so go over to the Home tab click on the conditional formatting drop down button select the new rule option in the pop-up select the option for using a formula in the text box type equals Rho a one followed by an equal sign and then the name we just created click the format button to select how you want the row you are working on to be highlighted go to the fill tab and select a color of your choice now just go ahead and click OK in both pop-ups all right as you can see we have our first roll highlighted but we wanted to be controlled by the current roll were working on to do this we need access to the Developer tab if you dont see it go to file options summize ribbon the developer checkbox a