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