View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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