Make cell locked based on value in another cell

[newbieX]

I want to control whether a cell is locked or not based on a value in another cell entered on a data entry form. The data entered in row by row, thus the cell column will remain the same but the row number will increase.

Thus I want a formula(or vba code?) in cell B1 to say IF(A1="No", unlock, lock) and so on down the column

How might I accomplish this. The worksheet is protected.

Excel 2010.

 

[newbieX]

I want to control whether a cell is locked or not based on a value in another cell entered on a data entry form. The data entered in row by row, thus the cell column will remain the same but the row number will increase.

Thus I want a formula(or vba code?) in cell B1 to say IF(A1="No", unlock, lock) and so on down the column

How might I accomplish this. The worksheet is protected.

Excel 2010.

I figure it out. In the formula box of Data Validation for the cell I entered

=IF(A1="NO",FALSE,TRUE)

It only works for cells that do not already have a Data Validation set so I still need to figure out how to tackle this issue for other cells that use pull down lists via Data Validation. Ideas anyone?