Conditional formatiing used to lock cells

[RodneyW]

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?

Thanks in advance

 

[Joe4]

I am pretty sure that you cannot use Conditional Formatting to lock cells - it just "formats" cells, as its name suggests.
I think what you want to do will require VBA.

The question is, how and when is cell H8 being populated with an "x"?

 

[RodneyW]

It’s simple user data entry typing the letter x into H8. If it requires VBA, then I need to find a different way to accomplish my goal

 

[Joe4]

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.
See: https://www.contextures.com/xlDataVal02.html