- Determine appropriate formatting based on formulas.
- Examine existing rules for conditional formatting.
- Identify how many colors are blended in color scales.
- Recall the location of the settings used to adjust transition levels between icons.
- Review the method used to quickly apply banded coloration to rows.
Skill Level Intermediate
- [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.