Contrary to popular belief, editing files online can be hassle-free. Sure, some file formats might appear too hard with which to deal. But if you have the right solution, like DocHub, it's straightforward to modify any document with minimum resources. DocHub is your go-to solution for tasks as simple as the ability to Collate Formatula Format For Free a single document or something as daunting as handling a huge stack of complex paperwork.
When it comes to a solution for online file editing, there are many solutions on the market. Yet, not all of them are powerful enough to accommodate the needs of people requiring minimum editing functionality or small businesses that look for more extensive set of features that enable them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing documents online more simplified and easier. Try DocHub now!
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