Conditional Formatting
What This Does
Conditional formatting applies colors, icons, or text styles when cells match rules—greater than, contains, duplicate, custom formula.
Why It's Useful
Scanning numbers for outliers is error-prone. Let color draw your eye to what matters.
How to Do It
- Format → Conditional formatting
- Set range and rule (e.g., Greater than 100)
- Choose fill color or color scale
- Use custom formula for complex logic: =AND(A1>0, B1<10)
Try This Now
Highlight all cells greater than a threshold in one column.
Mental Hook: Rules paint the signal.
