Exceljet

Quick, clean, and to the point

Conditional Formatting Formulas

This page shows formulas you can use to apply conditional formatting to highlight cells that meet specific conditions. For an overview of this topic, click here. For step-by-step video training, click here.

Excel formula: Conditional formatting numbers that include symbols

Conditional formatting numbers that include symbols

Excel formula: Conditional formatting unprotected cells

Conditional formatting unprotected cells

Excel formula: Highlight multiples of specific value

Highlight multiples of specific value

Excel formula: Shade alternating groups of n rows

Shade alternating groups of n rows

Excel formula: Highlight approximate match lookup conditional formatting

Highlight approximate match lookup conditional formatting

Excel formula: Highlight row and column intersection exact match

Highlight row and column intersection exact match

Excel formula: Highlight 3 smallest values with criteria

Highlight 3 smallest values with criteria

Excel formula: Conditional formatting highlight target percentage

Conditional formatting highlight target percentage

Excel formula: Highlight duplicate columns

Highlight duplicate columns

Excel formula: Find duplicate values in two columns

Find duplicate values in two columns

Excel formula: Highlight rows with blank cells

Highlight rows with blank cells

Excel formula: Highlight cells that contain one of many

Highlight cells that contain one of many

Excel formula: Highlight bottom values

Highlight bottom values

Excel formula: Highlight top values

Highlight top values

Excel formula: Conditional formatting gantt chart weekends

Conditional formatting gantt chart weekends

Excel formula: Conditional formatting gantt chart

Conditional formatting gantt chart

Excel formula: Conditional formatting dates overlap

Conditional formatting dates overlap

Excel formula: Highlight data by quartile

Highlight data by quartile

Excel formula: Highlight integers only

Highlight integers only

Excel formula: Highlight rows with dates between

Highlight rows with dates between

Excel formula: Highlight cells that equal

Highlight cells that equal

Excel formula: Highlight dates that are weekends

Highlight dates that are weekends

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 between

Highlight dates between

Excel formula: Highlight dates greater than

Highlight dates greater than

Excel formula: Highlight rows that contain

Highlight rows that contain

Excel formula: Highlight column differences

Highlight column differences

Excel formula: Highlight every other row

Highlight every other row

Excel formula: Highlight values that don't exist

Highlight values that don't exist

Excel formula: Highlight cells that end with

Highlight cells that end with

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 blank cells

Highlight blank cells

Excel formula: Highlight entire rows

Highlight entire rows

Excel formula: Highlight duplicate rows

Highlight duplicate rows

Excel formula: Highlight values not between X and Y

Highlight values not between X and Y

Excel formula: Highlight unique values

Highlight unique values

Excel formula: Highlight duplicate values

Highlight duplicate values

Excel formula: Highlight values between

Highlight values between

Excel formula: Highlight values greater than

Highlight values greater than

I LOVE your site. It helps me frequently as I have no formal training but I'm very logic oriented and this site is put together so very well and has assisted me so very much! You've improved the quality of my life. -Mike

Excel foundational video course

Excel Pivot Table video training course

Excel conditional formatting video course

Excel formulas and functions video training course

Excel Shortcuts Video Course