Conditional Proctection?
Is it possible to lock/unlock cells based on another cell value?
If cell = "text1" unlock cells A4:B4 and lock cells C4:D4 If cell = "text2"
unlock cells C4:D4 and lock cells A4:B4
The text1, text2 are from a combo box drop down list located on another
worksheet
Thanks
|