-
Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.
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.
Overview
Syllabus
-
Introduction
- Highlight data dynamically with conditional formatting
- 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
- Use data bars to display length or volume
- Use color scales to display relative differences
- Use icon sets to provide strong visual emphasis
- Apply conditional formatting across rows of data
- Identify cells with conditional formatting rules
- Resources
