View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matilda
 
Posts: n/a
Default Pick from a drop-down list

I have a protected form to be filled out. In one column I have a drop-down
list with 25 things in it to choose from. In adjacent column is dollar
amount to be added. One of these 25 things when I choose it, I want the
adjacent cell to be protected so it can't be filled in. I have looked in the
"if" function, but can't figure out how to do this. Does anyone have any
ideas?