conditional formatting

S

smack

Hi there,

I am trying to use conditional formatting to turn the cell red if the value
is not a dividend of 3...any suggestions would be great!
 
S

Stefi

I suppose you mean the value is not divisible by 3, e.g. 6 is divisible by 3,
7 is not. If so, apply this formula (say your values are in column A):

=MOD(A1,3)>0

Regards,
Stefi


„smack†ezt írta:
 
S

smack

Thanks Stefi...!

Stefi said:
I suppose you mean the value is not divisible by 3, e.g. 6 is divisible by 3,
7 is not. If so, apply this formula (say your values are in column A):

=MOD(A1,3)>0

Regards,
Stefi


„smack†ezt írta:
Click to expand...
 
Top