conditional formatting
 

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!

conditional formatting
 

Hi

FormatConditional FormattingFormula is =MOD(A1,3)<0

--
Regards

Roger Govier


"smack" wrote in message
...
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!

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!

conditional formatting
 

Thanks Stefi...!

"Stefi" wrote:

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!

conditional formatting
 

Thank you!!!

"Roger Govier" wrote:

Hi

FormatConditional FormattingFormula is =MOD(A1,3)<0

--
Regards

Roger Govier


"smack" wrote in message
...
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!

conditional formatting
 

You are welcome! Thanks for the feedback!
Stefi


€žsmack€� ezt Ã*rta:

Thanks Stefi...!

"Stefi" wrote:

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!