conditional formatting
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:
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!
|