Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Conditional Formatting for Beginners (Office 365/Excel 2019)

via LinkedIn Learning


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.


  • Highlight data dynamically with conditional formatting
1. Applying Conditional Formatting Rules
  • 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
2. Conditional Formatting Using Data Bars, Color Scales, and Icon Sets
  • Use data bars to display length or volume
  • Use color scales to display relative differences
  • Use icon sets to provide strong visual emphasis
3. Specialized Conditional Formatting Uses
  • Apply conditional formatting across rows of data
  • Identify cells with conditional formatting rules
  • Resources

Taught by

Dennis Taylor

Related Courses


Start your review of Excel: Conditional Formatting for Beginners (Office 365/Excel 2019)

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free