Control Cell Value

[mannm4]

I would like to control a cell value based on a value entered in another cell. For example, If in A1 "x" is entered then B1 can hold anything in range 2-4.
If in A1 "y" is entered then B1 can only be 0.

Currently I have Data Validation lists for both A1 and B1, but i want to add this extra validation step.

Any help is greatly appreciated.

[shg]

Custom validation for B1: =OR(AND(A1="y", B1=0), AND(A1="x", B1>=2, B1<=4))

If there's already validation, then you'd need to integrate it.