Thread: lock cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Novice Novice is offline
external usenet poster
 
Posts: 52
Default lock cells

Can I lock a condition alone in a cell so that the cell still can be modified

Example

in A1 I have a drop down list (select A, B ,C)
n B1 I have IF(A1="A","Ape",IF*(A1="B", "Banana",if(C1="","")))
How do I protect C1 from being deleted when users fill in the form?