Lock Unlock cells by criteria

[vijay.vizzu]

Hi...to all,

I have an idea, but i am not sure can it be done in excel or not. I just want to confirm that, in excel can cells be locked or unlocked by certain criteria,like if cell A1="india",then user can input in B1 cell, otherwise B1 can't input. and one more thing is in excel we can use "" for blank, and what we can use for non blank?


Any help will be appreciated, thanks to all

 

[Luke M]

Just to be clear, it sounds like you are using lock & unlock simply to refer to whether you can input into a cell (as in data validation) rather than protected cells (which have a "locked" property).


For your scenarion, the data validation rule in B1 would be:

=A1="india"

Make sure you also uncheck the box for "ignore blanks".


For your second question, the most common method is simply to say "not blank", as in:

=IF(A1<>"","There's something there!","It's blank!")

 

[vijay.vizzu]

Thank you so much luke,, but can you explain the procedure how to do this lock & unlock procedure, it not protected sheet, In validatation how can we do that

 

[SirJB7]

Hi, vijay.vizzu!

As far as I read and could understand, there are not lock or unlock methods used nor implemented. Just references to your typed words lock or unlock.

In Excel lock/unlock cells operates on protected worksheets.

With data validation what you can achieve is restrict what values you allow to be entered in a cell. But even you don't accept any value (for example restricting input to a list that results empty) that doesn't become a lock, it's just a validation; locks don't allow you to enter nor edit cell values.

Regards!