Conditional Formatting: When the Data Talks Back
Microsoft Copilot in Excel
James Chapman
AI Curriculum Manager, DataCamp
The Big Excel Challenge
Identifying and addressing
messy data
Missing values, duplicates, inconsistent entries →
misleading insights
Catch issues
early
so your analysis is built on solid ground
Conditional formatting
→ highlight data quality issues
Conditional Formatting to Surface Issues
Conditional formatting
= rules that highlight cells based on their value
Blanks
,
duplicates
, specific
status flags
stand out visually
Copilot can suggest formatting rules
Let's practice!
Microsoft Copilot in Excel
Preparing Video For Download...