I want to lock cells H9 - H49 if H8 has an x in it. I know I can use Conditional Formatting for font styles, cell color, etc., but I don't see a way to use it to lock cells, Is this possible and if so, how?
I don't know of any other way other than by VBA.
Perhaps you can use Data Validation, and have it choose an empty list, and not allow them to enter any other values. Not sure, you would have to play around with that.