Conditional Formating

[antfield]

I would like to have a range of cells checked to see if they are divisable by a number, such as money.like;

Mutiple Number to check
$0.05 $0.17
$0.10 $0.10
$0.20 $0.21

In this example, the
.17 example would highlight, as it can not be evenly divided by .05
.10 example would not highlight, as it is divisable by .10
.21 example would highlight as it can not be evenly divided by .20

Or is it possible to have it so the Cell will not accept an incorrect figure ?
I have only acceived this by using a list, although I do not want the List down Arrow to be displayed ?

Thanks

 

[PaddyD]

CF:

=mod(number,divisor)=0

 

[antfield]

CF:

=mod(number,divisor)=0

I tried this formula, although It does not work for me ?
=mod($B$2,.05)=0
Call b2 contacins the cell I want CF on. .05 stands for 5cents, I keep getting an error.

Any Ideas ?

Thanks for your Very fast Reply !

 

[PaddyD]

works for me:

format | conditional format - formula is:

=MOD($B$2,0.05)=0

...& set a format. Though you'll propbably want:

=MOD($B$2,0.05)<>0

...to highlight where things don't divide evenly

 

[Scott Huish]

Perhaps:

=ROUND(MOD($B$2,0.05),2)<>0

 

[antfield]

Too Right, It does work, although I found that I have to replace the "," in the Formula with a "|" pipe as in my Reginal Settings I have it as a list seperator..in place of the comma..

Thanks PaddyD your Formula work fine..

I appreciate your assistance.!