Skip to main content
Login
Cart
Exceljet
Quick, clean, and to the point
Training
Videos
Functions
Formulas
Shortcuts
Blog
Conditional Formatting Formulas
Quick Start
| Examples |
Troubleshooting
|
Training
Highlight 3 smallest values with criteria
Conditional formatting based on another cell
Conditional formatting based on another column
Conditional formatting column is blank
Conditional formatting date past due
Conditional formatting dates overlap
Conditional formatting highlight target percentage
Conditional formatting last n rows
Find duplicate values in two columns
Gantt chart
Gantt chart by week
Gantt chart time schedule
Gantt chart with weekends
Highlight approximate match lookup conditional formatting
Highlight blank cells
Highlight bottom values
Highlight cells that begin with
Highlight cells that contain
Highlight cells that contain one of many
Highlight cells that end with
Highlight cells that equal
Highlight column differences
Highlight data by quartile
Highlight dates between
Highlight dates greater than
Highlight dates in same month and year
Highlight dates in the next N days
Highlight dates that are weekends
Highlight duplicate columns
Highlight duplicate rows
Highlight duplicate values
Highlight entire rows
Highlight every other row
Highlight integers only
Highlight many matching values
Highlight missing values
Highlight multiples of specific value
Highlight numbers that include symbols
Highlight row and column intersection exact match
Highlight rows that contain
Highlight rows with blank cells
Highlight rows with dates between
Highlight top values
Highlight unique values
Highlight unprotected cells
Highlight values between
Highlight values greater than
Highlight values not between X and Y
Shade alternating groups of n rows
Download 100+ Important Excel Functions
Get over
100 Excel Functions
you should know in one handy PDF.
Email
HP
Your passion and care are evident in your attention to details, and at the same time you give details in perfect balance, simply, without overloading the end-user with too much information. I can't even begin to imagine how many people have become great assets to their employers because of you. -Jenny