Excel: Conditional Formatting for Beginners (2020)
34mBeginner2020-04-16
Authors
Dennis Taylor
Excel expert with 25+ years of experience
Course details
Conditional formatting sounds more complicated than it is. This powerful tool in Microsoft Excel allows you to highlight data based on cell contents, making it easy to spot trends and patterns and emphasize key results. Though this process can be quick and easy, many Excel users don't know how to use conditional formatting to its fullest potential. In this short course, Excel trainer Dennis Taylor walks you through how to apply and customize conditional formatting to quickly pinpoint variances in your data. Learn how to use all the rules and options, such as data bars and icon sets, and apply conditional formatting across many rows of data.
Skills covered
Office 365SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
Introduction
- Highlight data dynamically with conditional formatting
Applying Conditional Formatting Rules
- Format based on Highlight Cell Rules options
- Format based on unique or duplicate values
- Format based on Top Bottom Rules options
- Format based on formulas
Conditional Formatting Using Data Bars, Color Scales, and Icon Sets
- Use data bars to display length or volume
- Use color scales to display relative differences
- Use icon sets to provide strong visual emphasis
Specialized Conditional Formatting Uses
- Apply conditional formatting across rows of data
- Identify cells with conditional formatting rules
Conclusion
- Resources