Go to Data-Validation. In the "Allow" box choose custom and enter in this
formula:

=IF(A10,OR(B1=8,B1=0),B1=0)
--
Regards,
Dave


"Captnsvo23t" wrote:

Suppose I havea cell A1 and B1. I want to limit the input to cell b1. B!
can be 0, if cell A1 is 0 or blank. If A1 is than 0 (anywhole number) than
than cell b1 can be 8 or 0.