Home / MS-Excel / General Formatting

Control Conditional Formatting with Checkboxes

Conditional formatting, a feature available since Excel 97, applies formats to selected cells that meet criteria based on values or formulas you specify.

Although conditional formatting is usually applied based on cell values, applying it based on formulas provides the flexibility to extend the conditional formatting interface all the way to the spreadsheet grid.

Following these sections:

  • Setting Up Checkboxes for Conditional Formatting
  • Toggling Number Highlighting On and Off