Overview
-
Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.
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
