یکشنبه بیست و سوم آذر ۱۳۹۹ - 19:27 - حسين حسين پور -
Highlight multiples of specific value

Generic formula
=MOD(A1,value)=0
Summary
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
با نام و یاد خدا