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 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 200+ Excel Shortcuts
Get over
200 Excel shortcuts for Windows and Mac
in one handy PDF.
Email
HP
Out of all the Excel sites, this is by far the best. Very clean and useful tips and methods. It helped me a lot in my work. -Zoltán