Hi
do you want to use conditional format (CF) or a validation. Reading
your fist post I asumme the latter. To achieve this goto 'Data -
Validation' and enter the following formula:
=AND(X3=0,X3<=15000,MOD(X3,50)=0)
(dont forget the '=' sign)

Frank


Thanks Franks! that works great. I cant get the CF to work however.
This is what I am using for formula modified to fit my use.
AND(X3=0,X3<=15000,MOD(X3,50)=0) Acceptable values are 0-15000 by
50's Thanks again!