Dear all,

I have a sheet where I'd like to allow/disallow input of certain cells
based on the condition of another cell. For instance, if the value of
cell A1 is "Rectangular", I'd like to allow inputs for
length/width/height in cell A2, A3, and A4. If the value of A1 is
"Cylindrical", I want to disallow input in A2, A3, and A4, but allow
in A5 and A6 for diameter and depth.

Could you please recommend a strategy for processing such things?
In web programming you can conditionally disable or "gray out" input
field. Can such thing be implemented in Excel? If so, how do you do
it?

I'm fairly new to Excel and VBA (I actually started it yesterday :)
Your help will be greatly appreciated.

Thanks!
- B.R