How to lock a cell based on a choice in a dropdown box?

[g0dmenuelz]

Hello, I need help Vba masters.

This might need a vba, can anyone help me if this is possible?

I need to lock all other cell based on the salary grade level. I managed to highlight it based on manually putting conditional formatting with a color red on each box.

But is there anyway to have a vba code for this so instead of highlighting the cell it will be disabled or lock or uneditable instead?

I just need the formula or how it is done and I can study and hopefully apply the rest.

I'd really appreciate any help.

Thanks.