50 Conditional Formatting Formulas

Working Excel formulas for conditional formatting, with detailed explanations, videos, and related links. Includes formulas to highlight rows, cells, dates, duplicates, and more. See all Excel formulas.

Quick Links

Conditional formatting based on another cell

Conditional formatting based on another cell

Conditional formatting based on another column

Conditional formatting based on another column

Conditional formatting column is blank

Conditional formatting column is blank

Conditional formatting date past due

Conditional formatting date past due

Conditional formatting dates overlap

Conditional formatting dates overlap

Conditional formatting highlight target percentage

Conditional formatting highlight target percentage

Conditional formatting last n rows

Conditional formatting last n rows

Find duplicate values in two columns

Find duplicate values in two columns

Gantt chart

Gantt chart

Gantt chart by week

Gantt chart by week

Gantt chart time schedule

Gantt chart time schedule

Gantt chart with weekends

Gantt chart with weekends

Highlight 3 smallest values with criteria

Highlight 3 smallest values with criteria

Highlight approximate match lookup conditional formatting

Highlight approximate match lookup conditional formatting

Highlight blank cells

Highlight blank cells

Highlight bottom values

Highlight bottom values

Highlight cells that begin with

Highlight cells that begin with

Highlight cells that contain

Highlight cells that contain

Highlight cells that contain one of many

Highlight cells that contain one of many

Highlight cells that end with

Highlight cells that end with

Highlight cells that equal

Highlight cells that equal

Highlight column differences

Highlight column differences

Highlight data by quartile

Highlight data by quartile

Highlight dates between

Highlight dates between

Highlight dates greater than

Highlight dates greater than

Highlight dates in same month and year

Highlight dates in same month and year

Highlight dates in the next N days

Highlight dates in the next N days

Highlight dates that are weekends

Highlight dates that are weekends

Highlight duplicate columns

Highlight duplicate columns

Highlight duplicate rows

Highlight duplicate rows

Highlight duplicate values

Highlight duplicate values

Highlight entire rows

Highlight entire rows

Highlight every other row

Highlight every other row

Highlight integers only

Highlight integers only

Highlight many matching values

Highlight many matching values

Highlight missing values

Highlight missing values

Highlight multiples of specific value

Highlight multiples of specific value

Highlight numbers that include symbols

Highlight numbers that include symbols

Highlight row and column intersection exact match

Highlight row and column intersection exact match

Highlight rows that contain

Highlight rows that contain

Highlight rows with blank cells

Highlight rows with blank cells

Highlight rows with dates between

Highlight rows with dates between

Highlight specific day of week

Highlight specific day of week

Highlight top values

Highlight top values

Highlight unique values

Highlight unique values

Highlight unprotected cells

Highlight unprotected cells

Highlight values between

Highlight values between

Highlight values greater than

Highlight values greater than

Highlight values not between X and Y

Highlight values not between X and Y

Shade alternating groups of n rows

Shade alternating groups of n rows

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

I just wanted to say what a fantastic resource ExcelJet is. I never fail to be impressed by the quality of examples and explanations. I have never been let down by this site. This is definitely the go-to place for Excel knowledge.

Dave in NZ

More Testimonials