Exceljet

Quick, clean, and to the point

Conditional Formatting Formulas

Quick Start | Examples | Troubleshooting | Training
Excel formula: Highlight 3 smallest values with criteria
Highlight 3 smallest values with criteria
Excel formula: Conditional formatting based on another cell
Conditional formatting based on another cell
Excel formula: Conditional formatting based on another column
Conditional formatting based on another column
Excel formula: Conditional formatting column is blank
Conditional formatting column is blank
Excel formula: Conditional formatting date past due
Conditional formatting date past due
Excel formula: Conditional formatting dates overlap
Conditional formatting dates overlap
Excel formula: Conditional formatting highlight target percentage
Conditional formatting highlight target percentage
Excel formula: Conditional formatting last n rows
Conditional formatting last n rows
Excel formula: Find duplicate values in two columns
Find duplicate values in two columns
Excel formula: Gantt chart
Gantt chart
Excel formula: Gantt chart by week
Gantt chart by week
Excel formula: Gantt chart time schedule
Gantt chart time schedule
Excel formula: Gantt chart with weekends
Gantt chart with weekends
Excel formula: Highlight approximate match lookup conditional formatting
Highlight approximate match lookup conditional formatting
Excel formula: Highlight blank cells
Highlight blank cells
Excel formula: Highlight bottom values
Highlight bottom values
Excel formula: Highlight cells that begin with
Highlight cells that begin with
Excel formula: Highlight cells that contain
Highlight cells that contain
Excel formula: Highlight cells that contain one of many
Highlight cells that contain one of many
Excel formula: Highlight cells that end with
Highlight cells that end with
Excel formula: Highlight cells that equal
Highlight cells that equal
Excel formula: Highlight column differences
Highlight column differences
Excel formula: Highlight data by quartile
Highlight data by quartile
Excel formula: Highlight dates between
Highlight dates between
Excel formula: Highlight dates greater than
Highlight dates greater than
Excel formula: Highlight dates in same month and year
Highlight dates in same month and year
Excel formula: Highlight dates in the next N days
Highlight dates in the next N days
Excel formula: Highlight dates that are weekends
Highlight dates that are weekends
Excel formula: Highlight duplicate columns
Highlight duplicate columns
Excel formula: Highlight duplicate rows
Highlight duplicate rows
Excel formula: Highlight duplicate values
Highlight duplicate values
Excel formula: Highlight entire rows
Highlight entire rows
Excel formula: Highlight every other row
Highlight every other row
Excel formula: Highlight integers only
Highlight integers only
Excel formula: Highlight missing values
Highlight missing values
Excel formula: Highlight multiples of specific value
Highlight multiples of specific value
Excel formula: Highlight numbers that include symbols
Highlight numbers that include symbols
Excel formula: Highlight row and column intersection exact match
Highlight row and column intersection exact match
Excel formula: Highlight rows that contain
Highlight rows that contain
Excel formula: Highlight rows with blank cells
Highlight rows with blank cells
Excel formula: Highlight rows with dates between
Highlight rows with dates between
Excel formula: Highlight top values
Highlight top values
Excel formula: Highlight unique values
Highlight unique values
Excel formula: Highlight unprotected cells
Highlight unprotected cells
Excel formula: Highlight values between
Highlight values between
Excel formula: Highlight values greater than
Highlight values greater than
Excel formula: Highlight values not between X and Y
Highlight values not between X and Y
Excel formula: Shade alternating groups of n rows
Shade alternating groups of n rows