Excel question

[Cole1]

Can anyone help me with a formula. I have a large spreadsheet that i want to highlight all numbers that are divisible, in whole numbers, by 8. Seems easy but my excel is not that good.

I think I need one of the IF formulas but not sure how to write it.
Thanks in advance for your help!!!

 

[galactus]

One command you could try is:

=IF(MOD(cell#,8)=0,1,2)

If it is divisible by 8 it displays 1. If it is not divisible by 8 it displays 2.

Then highlight the cells that have 1's in them.

Does this help?.

 

[Cole1]

Thanks a ton. I think I can make it work from there. I really appreciate the assistance.