| 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 |
