Conditional Formatting
This section contains examples that demonstrate how to use conditional formatting to highlight important information and make data interpretation easier. Conditional formats such as cell background color, border line style or font color can be applied to cells whose values meet a certain condition specified by a conditional formatting rule.
- How to: Format Cell Values that are Above or Below the Average
- How to: Format Cells that are Between or Not Between Two Values
- How to: Format Top or Bottom Ranked Values
- How to: Format Cells based on the Text in the Cell
- How to: Format Unique or Duplicate Values, Blank Cells and Formula Errors
- How to: Format Cells that Contain Dates
- How to: Format Cells that are Less than, Greater than or Equal to a Value
- How to: Use a Formula to Determine which Cells to Format
- How to: Format Cells Using a Two-Color Scale
- How to: Format Cells Using a Three-Color Scale
- How to: Format Cells Using Data Bars
- How to: Format Cells Using Icon Sets