## Highlight multiples of specific value in Excel

This tutorial shows how to Highlight multiples of specific value in Excel using the example below; Formula =MOD(A1,value)=0 Explanation 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: …