
Conditional Formatting
Conditional Formatting is a great way to create dashboards in Excel that automatically change colors and icons based on your data. Conditional Formatting is also very helpful when reviewing new data. You can quickly and easily focus on the most important trends or outliers in your data. Watch this series of Excel Videos and read the four articles below, then test your knowledge with the sample spreadsheet used in the articles. By the time you finish, you’ll be well on your way to mastering Conditional Formatting.
Excel Video 44 Introducing Conditional Formatting
Welcome to the next set of Excel Videos. We’ve covered Pivot Tables and Tables in Excel 2007 in depth. ...
Excel Video 45 Highlight Cells Rules, Part 1
Excel Video 45 starts at the top of the Conditional Formatting menu with the Highlight Cells Rules. ...
Excel Video 46 Highlight Cells Rules, Part 2
Excel Video 46 describes how to highlight specific dates and how to find duplicate values using conditional...
Excel Video 47 Top Bottom Rules
Excel Video 47 reviews the three sets of Top/Bottom Rules, Top/Bottom x Items, Top/Bottom x Percent, and...
Excel Video 48 Data Bars
Excel Video 48 covers a Conditional Formatting tool called Data Bars. Data Bars are simply a way to format...
Excel Video 49 Color Scales
Excel Video 49 introduces Color Scales, another Conditional Formatting tool I think you’ll find useful. ...
Excel Video 50 Icon Sets, Part 1
Watch Excel 50 to learn how to use a variety of Excel’s icon sets in conditional formatting. Icon sets can...
Excel Video 51 Icon Sets, Part 2
Excel Video 51 demonstrates more ways to use Icon Sets in Conditional Formatting. In this example, I have...
Excel Video 52 Format Based on Values
Excel Video 52 continues our discussion of Conditional Formatting. We’ve been through each of the major...
Excel Video 53 Conditional Formatting Errors and Blanks
Excel Video 53 shows an easy way to format all blank cells or error cells in part or all of your spreadsheet....
Excel Video 54 Top or Bottom Rules
Excel Video 54 is a straight-forward demonstration of how the Top or Bottom Rules work in Conditional...
Excel Video 55 Above or Below Average
Watch Excel Video 55 to learn how to conditionally format cells that are above or below the average of the...
Excel Video 56 Formulas in Conditional Formatting
Excel Video 56 shows how to conditionally format cells based on a formula. If the formula is true, Excel...
Excel Video 57 Find and Clear Conditional Formatting
Excel Video 57 is a short, easy discussion on how to find conditionally formatted cells and how to clear...
Excel Video 58 Manage Rules
Excel Video 58 introduces the idea of multiple conditional formatting rules applied to the same range of...
Excel Video 59 Manage Conflicting Rules
Excel Video 59 continues our review of what Excel does when multiple Conditional Formatting rules are applied...
Excel Video 60 Stop If True
Excel Video 60 wraps up our discussion of Conditional Formatting with a discussion of the Stop If True box in...