Conditional Formatting

Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based values.

Quick Links

Excel formula: Highlight 3 smallest values with criteria

Conditional formatting

Highlight 3 smallest values with criteria

Excel formula: Conditional formatting based on another cell

Conditional formatting

Conditional formatting based on another cell

Excel formula: Conditional formatting based on another column

Conditional formatting

Conditional formatting based on another column

Excel formula: Conditional formatting column is blank

Conditional formatting

Conditional formatting column is blank

Excel formula: Conditional formatting date past due

Conditional formatting

Conditional formatting date past due

Excel formula: Conditional formatting dates overlap

Conditional formatting

Conditional formatting dates overlap

Excel formula: Conditional formatting highlight target percentage

Conditional formatting

Conditional formatting highlight target percentage

Excel formula: Conditional formatting last n rows

Conditional formatting

Conditional formatting last n rows

Excel formula: Find duplicate values in two columns

Conditional formatting

Find duplicate values in two columns

Excel formula: Gantt chart

Conditional formatting

Gantt chart

Excel formula: Gantt chart by week

Conditional formatting

Gantt chart by week

Excel formula: Gantt chart time schedule

Conditional formatting

Gantt chart time schedule

Excel formula: Gantt chart with weekends

Conditional formatting

Gantt chart with weekends

Excel formula: Highlight approximate match lookup conditional formatting

Conditional formatting

Highlight approximate match lookup conditional formatting

Excel formula: Highlight blank cells

Conditional formatting

Highlight blank cells

Excel formula: Highlight bottom values

Conditional formatting

Highlight bottom values

Excel formula: Highlight cells that begin with

Conditional formatting

Highlight cells that begin with

Excel formula: Highlight cells that contain

Conditional formatting

Highlight cells that contain

Excel formula: Highlight cells that contain one of many

Conditional formatting

Highlight cells that contain one of many

Excel formula: Highlight cells that end with

Conditional formatting

Highlight cells that end with

Excel formula: Highlight cells that equal

Conditional formatting

Highlight cells that equal

Excel formula: Highlight column differences

Conditional formatting

Highlight column differences

Excel formula: Highlight data by quartile

Conditional formatting

Highlight data by quartile

Excel formula: Highlight dates between

Conditional formatting

Highlight dates between

Excel formula: Highlight dates greater than

Conditional formatting

Highlight dates greater than

Excel formula: Highlight dates in same month and year

Conditional formatting

Highlight dates in same month and year

Excel formula: Highlight dates in the next N days

Conditional formatting

Highlight dates in the next N days

Excel formula: Highlight dates that are weekends

Conditional formatting

Highlight dates that are weekends

Excel formula: Highlight duplicate columns

Conditional formatting

Highlight duplicate columns

Excel formula: Highlight duplicate rows

Conditional formatting

Highlight duplicate rows

Excel formula: Highlight duplicate values

Conditional formatting

Highlight duplicate values

Excel formula: Highlight entire rows

Conditional formatting

Highlight entire rows

Excel formula: Highlight every other row

Conditional formatting

Highlight every other row

Excel formula: Highlight integers only

Conditional formatting

Highlight integers only

Excel formula: Highlight many matching values

Conditional formatting

Highlight many matching values

Excel formula: Highlight missing values

Conditional formatting

Highlight missing values

Excel formula: Highlight multiples of specific value

Conditional formatting

Highlight multiples of specific value

Excel formula: Highlight numbers that include symbols

Conditional formatting

Highlight numbers that include symbols

Excel formula: Highlight row and column intersection exact match

Conditional formatting

Highlight row and column intersection exact match

Excel formula: Highlight rows that contain

Conditional formatting

Highlight rows that contain

Excel formula: Highlight rows with blank cells

Conditional formatting

Highlight rows with blank cells

Excel formula: Highlight rows with dates between

Conditional formatting

Highlight rows with dates between

Excel formula: Highlight specific day of week

Conditional formatting

Highlight specific day of week

Excel formula: Highlight top values

Conditional formatting

Highlight top values

Excel formula: Highlight unique values

Conditional formatting

Highlight unique values

Excel formula: Highlight unprotected cells

Conditional formatting

Highlight unprotected cells

Excel formula: Highlight values between

Conditional formatting

Highlight values between

Excel formula: Highlight values greater than

Conditional formatting

Highlight values greater than

Excel formula: Highlight values not between X and Y

Conditional formatting

Highlight values not between X and Y

Excel formula: Shade alternating groups of n rows

Conditional formatting

Shade alternating groups of n rows

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

You guys rock, you have helped me more times in completing a work project than I can even count over the past year and a half. Keep fighting the good fight!

Mitch

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Charts video training course

Video training for Excel Tables

Dynamic Array Formulas