Custom data validation that locks the cell as per the value in the other cell.

[Yeshika44]

Hi there

My question is related to the custom data validation that locks the cell as per the value in the other cell.

I have two data columns (G1:G1000 and K1:K1000). My question is, if we enter “Open” in cell range G, then unlock the specific cell in column “K” and open drop down with Yes & No. If we have “Close” in cell range “G”, then specific cell in column “K” should restrict the value entry and move the cursor to column “L”. Basically, column “J” value is based on Column “K”. This should apply throughout whole range (G1:G1000 and G4:U1000).

I tried following code, but it doesn’t work, I would greatly appreciate if anyone can help.

Thanks heaps

Yeshi

 

[Fluff]

Cross-posted without links again.


Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Custom data validation that locks the cell as per the value in the other cell.
Please post links to ALL other sites where you have asked this question.