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

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


"DDude" wrote:

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