Locking cells beased on another cell's value

[bsutton19]

I need help locking cells in a range that is copied from another sheet based on user input. I am able to change the color with conditional formatting, but can not figure out how to lock out cells that are part pf a header. A simplified example is:

Cells A1:A100 are mostly input cells. However, if a corresponding cell in B1:B100 = 1, the matching "A" cell needs to be locked. What code can I use to make this happen?

 

[Joe4]

This looks like an extension of this question you asked earlier today: https://www.mrexcel.com/forum/excel-questions/1059311-lock-cell-based-adjacent-cell-value.html
So please continue on in that thread.

All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).