conditional formatting??
 

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

conditional formatting??
 

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

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


.

conditional formatting??
 

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

Joann wrote:
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

.