Contrary to popular belief, working on files online can be trouble-free. Sure, some file formats might seem too hard with which to work. But if you get the right solution, like DocHub, it's easy to tweak any file with minimum resources. DocHub is your go-to solution for tasks as simple as the option to Build Conditional Field Format For Free a single document or something as daunting as dealing with a huge stack of complex paperwork.
When it comes to a tool for online file editing, there are many solutions on the market. However, 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 allow them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing documents online more simplified and easier. Sign up for 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