Highlight cells with conditional formatting
Updated November 13, 2026
Conditional formatting changes how a cell looks when its value meets a rule, and updates as the numbers change.
Add a rule
- Select the cells.
- Choose Home › Conditional.
- Pick a kind:
- Highlight Cells Rules: Greater Than…, Less Than…, Between…, Equal To…, Text that Contains…, A Date Occurring… or Duplicate Values….
- Top/Bottom Rules: Top 10 Items…, Top 10%…, Bottom 10 Items…, Bottom 10%…, Above Average… or Below Average….
- Data Bars, Color Scales or Icon Sets.
- Fill in the value and the look, then choose OK.
Change or remove rules
- Home › Conditional › Manage Rules… lists every rule, where it applies and in what order. Edit, delete or reorder them there.
- New Rule… writes a rule of your own, including one based on a formula.
- Clear Rules from Selected Cells or Clear Rules from Entire Sheet removes them.