What it does
Conditional formatting highlights values, dates, duplicates and rules visually.
Syntax or pattern
Workflow steps vary by workbook✅
5 practical examples
1
Highlight overdue dates
Use a rule for dates before today.
=A2<TODAY()Apply to due-date cells.
2
Highlight top values
Use Top 10 Items or a formula rule.
Home → Conditional Formatting → Top/Bottom RulesGood for quick analysis.
3
Color negative values
Format values below zero.
=B2<0Useful for variance reports.
4
Highlight duplicates
Use duplicate value formatting.
Home → Conditional Formatting → Highlight Cells Rules → Duplicate ValuesGood for data cleanup.
5
Data bars for progress
Apply data bars to percent complete.
Home → Conditional Formatting → Data BarsMakes progress columns easier to scan.
Common mistakes to avoid
- Keep raw data separate from reports.
- Use clear table names and labels.
- Avoid over-formatting before the data structure is stable.
Related Excel examples
FAQ
Can this be combined with formulas?
Yes. Most Excel workflows work best when formulas, tables and formatting support each other.