Formula Related Functions
Conditional formatting based on another cell
Conditional formatting based on another column
Conditional formatting column is blank OR AND NOT
Conditional formatting date past due TODAY
Conditional formatting dates overlap SUMPRODUCT
Conditional formatting highlight target percentage
Conditional formatting last n rows
Find duplicate values in two columns COUNTIF AND
Gantt chart AND
Gantt chart by week AND
Gantt chart time schedule AND OR
Gantt chart with weekends WEEKDAY
Highlight 3 smallest values with criteria SMALL AND
Highlight approximate match lookup conditional formatting LOOKUP OR AND
Highlight blank cells ISBLANK LEN
Highlight bottom values SMALL
Highlight cells that begin with COUNTIF FIND
Highlight cells that contain SEARCH FIND ISNUMBER
Highlight cells that contain one of many SEARCH FIND ISNUMBER SUMPRODUCT
Highlight cells that end with COUNTIF RIGHT LEN EXACT
Highlight cells that equal EXACT
Highlight column differences EXACT NOT
Highlight data by quartile QUARTILE
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 columns SUMPRODUCT COUNTIF
Highlight duplicate rows COUNTIFS COUNTIF SUMPRODUCT
Highlight duplicate values COUNTIF
Highlight entire rows
Highlight every other row ISEVEN ISODD ROW MOD
Highlight integers only MOD
Highlight many matching values COUNTIF
Highlight missing values COUNTIF
Highlight multiples of specific value MOD
Highlight numbers that include symbols ISNUMBER MID
Highlight row and column intersection exact match OR AND
Highlight rows that contain SEARCH FIND
Highlight rows with blank cells COUNTBLANK
Highlight rows with dates between DATE AND
Highlight specific day of week TEXT
Highlight top values LARGE
Highlight unique values COUNTIF
Highlight unprotected cells CELL
Highlight values between AND
Highlight values greater than
Highlight values not between X and Y AND NOT
Shade alternating groups of n rows ROW CEILING ISEVEN ISODD