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?