dividing cells by 15 and marking equal divisions

[janus67]

I have a column of numbers for example from A1 to A250 etc and I wish to mark somehow when the number is divisible by 15 exactly
so you could say I want to sort & mark the numbers divisible by 15 only

ie ColA1/15 to ColA14/15 the answer would be NIL as there's a remainder so no mark

ColA15 /15 =1 ( that would mean marking the cell somehow( or another cell , the simplest way)

Col16/15 to Col29/15 answer is nil again ( no mark, not divisible by 15 equally)

Col30 /15 =2 -- again a mark made
etc
MOD15 would divide the cells ok, but how to mark the cells divisible by 15?
I'd appreciate any help or advice here

thanks
Keith

 

[Peg F]

Thanks, Keith, for the feedback.

Take care,

Peg