Conditional Formatting

Conditional formatting changes a cell's look automatically based on its value — so patterns, outliers, and problems stand out without anyone reading every number.

Select the cells, then choose Home ▸ Conditional Formatting. The formatting is live: when a value changes, its formatting updates too.

Use it for a purpose — flag overdue dates, low stock, or top performers — rather than coloring everything.