Get an overview of how to use conditional formatting options available in MS Excel 2010 and later, including data bars, color scales, and icon sets.
You've dabbled in Highlight Cells Rules in the previous lesson; now continue mastering this MS Excel function in this lesson from MyExcelOnline.
Find out how to use conditional formatting to highlight the top and bottom values of a data set in an MS Excel pivot table containing quarterly revenue data.
Data bars, color scales, and icon sets are new formatting features in MS Excel 2010 and later. Find out how they can make data analysis a lot easier!
Learn how to use field-specific formatting to identify salespeople who will receive a bonus. Create tailor-made conditional formatting to suit your needs.
- Recommended Recommended
- History & In Progress History
- Browse Library
- Most Popular Library
Get Personalized Recommendations
Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.Start Interview
You don't have any lessons in your history.
Just find something that looks interesting and start learning!