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.

• Introduction
• 1. Applying Conditional Formatting Rules
• 2. Conditional Formatting Using Data Bars, Color Scales, and Icon Sets
• 3. Specialized Conditional Formatting Uses
• Conclusion