Conditional cell lock?

  • Thread starter Thread starter Bob Rooney
  • Start date Start date
B

Bob Rooney

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
 
Look in Excel in the Data menu, choose validation. You would need to write
formulas that supports your conditions. I don't think you can totally
disallow entry, but you could only accept something like Z%$ZX
 
Back
Top