Conditional Format multiples of a number

[JakeMann]

Hi All,

If I have a list of numbers 1-200 for example, I would like to highlight the cell that says 24 and it's multiples... so 24, 48, 72 etc.

Is that possible?

[XOR LX]

Hi,

Assuming your list is in A1:A200 then, with A1 the active cell, highlight the range A1:A200 and create a new formula-based Conditional Formatting rule with this in the Format values where this formula is true: box:

=MOD(A1,24)=0

Select your format as desired.

Regards

[ben_hensel]

Use "Conditional Formatting with a formula"

The formula is:
in cell A1:
=MOD(A1, 24) =0

This will return TRUE if the remainder of whatever's in the cell / 24 is 0, and FALSE if it is not.

[JakeMann]

Brilliant, thanks guys, exactly what I needed.

[XOR LX]

You're welcome.