Excel Conditional Formatting
Conditional formatting turns raw spreadsheets into visual dashboards — colored cells, data bars, icon sets, and heat maps that make patterns and outliers jump out. This hub gathers everything on highlighting rules, color scales, data bars, icon sets, and custom-formula rules that unlock the real power.
What's on this page
Complete Guide
The full pillar — every conditional formatting type, how to apply them, custom-formula rules, managing multiple rules, and the patterns that actually earn their keep in real workbooks.
How-To Posts
Related tutorials on specific formatting tasks.
Related Clusters
Formatting rules without the formula gymnastics
Custom-formula conditional formatting with mixed absolute/relative references is where most users get stuck. Excel Wizard generates the rule from plain English ("highlight overdue rows in red, due-this-week in amber") with the references wired correctly.
Install Excel Wizard →