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

Yeshika44

New Member
Joined
Aug 26, 2024
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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
 

Attachments

  • Code 2.jpg
    Code 2.jpg
    49.5 KB · Views: 2
  • Spreadsheet.jpg
    Spreadsheet.jpg
    50.1 KB · Views: 2

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Upvote 0

Forum statistics

Threads
1,223,374
Messages
6,171,713
Members
452,418
Latest member
kennettz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top