Conditional Formatting

Summary

Automatically highlighting cells based on rules (color scales, data bars, icon sets) — turning a table of numbers into something a stakeholder can scan in seconds.

• 1Apply a color scale to a numeric column to spot highs and lows instantly.
• 2Build a custom rule (e.g. highlight cells below a target threshold).
• 3Learn where conditional formatting helps versus where it just adds visual noise.