PDA

View Full Version : Lock/Unlock cells based on values in parent cell



Juriemagic
08-24-2015, 12:30 AM
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...