You know you are using the proper document editor when such a basic job as Lock up highlight text does not take more time than it should. Modifying documents is now a part of many working operations in various professional areas, which is the reason convenience and straightforwardness are crucial for editing tools. If you find yourself researching tutorials or searching for tips on how to Lock up highlight text, you may want to get a more intuitive solution to save your time on theoretical learning. And here is where DocHub shines. No training is required. Simply open the editor, which will guide you through its main functions and features.
A workflow gets smoother with DocHub. Take advantage of this instrument to complete the documents you need in short time and get your efficiency to another level!
Todays video is about Conditional Formatting in Excel. Im going to show you how you can use formulas in Conditional Formatting and how you can conditionally format a range based on the value of another cell. So for example, conditionally format a row in Excel based on a sales value in that row? This way you can highlight a row or adjust the font color of a row based on another cell. Its going to be fun. Lets get to it. (upbeat music) In this example, I have lists of names and the yearly salary for each person. I want to format the values order rows if the salary is greater than or equal to the salary I type in here. So Im going to do two different versions of this. In the first version, I just want to highlight the values, in the second version I want to highlight the rows where this condition is true because Im adjusting the formatting based on a condition, I need to use Conditional Formatting. So first thing I need to do is highlight the range I want to format, go to Condition