Conditionally locking the cell

Hi vickey.narang
I havent looked at the workbook but maybe you can adapt something like this...

Please Login or Register  to view this content.

just change the ranges and the a1 to the drop down box range

hmmm. cant think of an easy way. Could you enter the data via a userform?

Originally Posted by vickey.narang

Hii
I have a problem. I want to conditionally lock cells based on one cell. Suppose if D5 is entered from data validation drop down. 1 is entered then E5 H5 I5 should be locked
Similarly if E5 is entered then D5 H5 I5 should be locked and same for others like H5 and I5.
If data is removed. The cells should be unlocked again. There are 60 similar rows for individual entries. I am attaching a file. Grey cells should be locked. I tried to search but could not find the appropriate result. I will be thankful if you provide me the solutions
Thanks a lot.

I presume that every cell is unlocked prior the the user changing one. After they have changed one, you want the others locked.
Not sure if this is what you meant. This will lock the gray cells when you change one of the dropdowns.
I haven't tested this, so there may be syntax errors.

Please Login or Register  to view this content.