Conditional Values

[DDude]

I am trying to figure a way to make the following happen:

I have a list box in cell A1. If the person chooses say "car" from the list
in A1 I want the value of cell B2 to be a formula such as =(2*c2). If the
person chooses any other value from the list in A1 I want them to be able to
enter a number into cell B2 then.

Similarly, if they choose "car" I want them to be able to enter a value into
D2 and if they choose any other value from the list then I want cell D2 to be
blocked from entry.

Thanks

 

[Teethless mama]

Data > Validation > Settings tab > Allow: select Custom > Formula: =A1="Car"