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
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