Good morning,

I have found numerous examples of ways to lock/unlock cells based on the value of one cell, my situation is slightly different. I have cells in multiple columns: H5, H7, H9, I5, I7, I9, I11, J5, J7, J9. Their parent cells are N5, N6, N7, N8, N9, N10, N11, N12, N13, N14. I would like cells in the first range locked if the value in the corresponding parent cell equals 0.

I would honestly appreciate all and any help with this. Thank you all kindly...