Learn how to use Excel's conditional formatting to highlight data dynamically, to emphasize key results or spot trends and patterns in your spreadsheets.
- [Dennis] Hi, I'm Dennis Taylor and welcome to this course on Conditional Formatting in Excel. When displaying data, sometimes the numbers just don't tell the story as vividly as you might want. Conditional formatting has the tools to apply different cell background colors or font colors based on content differences that can give added weight to the data that you want to emphasize. I'll show you how you can use conditional formatting with pivot tables and data validation, and I'll show you how to use features like data bars, color scales, and icon sets that make your data even more eye-catching so you can easily spot trends and patterns in your data.
Conditional formatting is a popular and rich feature with lots of capability. So, let's get started with conditional formatting.
- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows