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

  1. Select the cells.
  2. Choose Home › Conditional.
  3. 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.
  4. 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.

Was this article helpful?