conditional formatting??

[Joann]

I have a column that I would like for the value that is put in there to
hilight if it is not divisible by a certain number.

For example....If the number I put in column A is not divisible by the
number in column c, I would like the value that I put in column A to
hilight....how do I do this?

Thanks!

Joann

 

[David Biddulph]

CF/ Formula Is/ =MOD(A1/C1,1)<>0
or
CF/ Formula Is/ =MOD(A1,C1)<>0

 

[Joann]

Where do I put this though?

CF/ Formula Is/ =MOD(A1/C1,1)<>0
or
CF/ Formula Is/ =MOD(A1,C1)<>0
--
David Biddulph




.

 

[Glenn]

Look at "Add, change, or remove conditional formats" in the help file.