Home » Posts

Highlight multiples of specific value

To highlight numbers that are multiples of a another number with conditional formatting, you can use a simple formula based on the MOD function. In the example shown, the formula used to highlight multiples of 9 is: =MOD(B4,$E$2)=0 Note: formula is entered relative to the "active cell" in the selection, cell B4 in this case.

April 14, 2025 · 1 min · 44 words · Colton Flowers

When MOD returns zero, the expression returns TRUE and the conditional formatting applies.

When MOD returns any other result, the expression returns FALSE conditional formatting is not applied.

For example, MOD(10,3) = 1.

Excel formula: Highlight values greater than

The result of MOD carries the same sign as the divisor.

Excel formula: Highlight values not between X and Y

Excel MOD function