Conditional Formatting on a cell based on if it is a multiple of 7

[bran987]

In other words is there any way to shade a cell green only if the number contained in it is evenly divisible by 7?

Thanks

 

[iliace]

=(mod(a1, 7)=0)

 

[bran987]

=(mod(a1, 7)=0)

Thank you!

I need to add one more condition, and that is:

is there any way to set a conditional format for if the number contained in it is NOT evenly divisible by 7?

 

[Peter_SSs]

I think the obvious modification would be:
=MOD(a1, 7)<>0

 

[iliace]

If it's evenly divisible, the remainder is zero. If it's not, the remainder is not zero. MOD([number], [divisor]) will give you the remainder of [number] divided by [divisor].