Highlight blank cells |
ISBLANK LEN |
Highlight cells that begin with |
IFERROR COUNTIF FIND |
Highlight cells that contain |
ISNUMBER FIND SEARCH |
Highlight cells that end with |
COUNTIF EXACT LEN RIGHT |
Highlight cells that equal |
EXACT |
Highlight column differences |
NOT EXACT |
Highlight dates between |
DATE AND |
Highlight dates greater than |
DATE |
Highlight dates in same month and year |
DATE TEXT |
Highlight dates in the next N days |
TODAY AND |
Highlight dates that are weekends |
WEEKDAY OR |
Highlight duplicate rows |
SUMPRODUCT COUNTIF COUNTIFS |
Highlight duplicate values |
COUNTIF |
Highlight entire rows |
|
Highlight every other row |
ISEVEN ISODD ROW MOD |
Highlight integers only |
MOD |
Highlight rows that contain |
FIND SEARCH |
Highlight rows with dates between |
DATE AND |
Highlight unique values |
COUNTIF |
Highlight values between |
AND |
Highlight values greater than |
|
Highlight values not between X and Y |
AND NOT |
Highlight values that don't exist |
COUNTIF |