Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Conditional Formatting Formulas

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

  • Quick Start
  • Examples
  • Troubleshooting
  • Training
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

Get PDF Guide

I do an excel-intensive project once a year, which means I constantly have to relearn formulas. This is the first year in which your website has repeatedly popped up when I google for help on a formula. The website is incredibly clear and useful.
Rebecca
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
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2023 Exceljet. Terms of use
  • Visit our Twitter page