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

Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.

Introduction

• Highlight data dynamically with conditional formatting

1. Applying Conditional Formatting Rules

• Format based on Highlight Cells 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

Conclusion

• Where to learn more