conditional formatting??
Where do I put this though?
"David Biddulph" wrote:
CF/ Formula Is/ =MOD(A1/C1,1)<0
or
CF/ Formula Is/ =MOD(A1,C1)<0
--
David Biddulph
"Joann" wrote in message
...
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
.
|