View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shawn Conn Shawn Conn is offline
external usenet poster
 
Posts: 3
Default Conditional Column Display

I am having trouble trying to figure this one out:

I am having customers fill out a form for me in excel, and am running into
issues with the data they are inputting. I think the best way to correct this
would be to restrict the fields that they can edit.
For instance: If a customer chose 'BI' from the drop down menu in column A,
I want him/her to be able to edit the neighboring cell in column B. Either by
having Column B hidden naturally, and only shown when 'BI' is selected, or
have it shown but can only be edited when 'BI' is selected.