Excel table formula

Job ID: 37276840

Budget: $10 – $30 USD

I have an excel file. In that excel file there is a drop down list. When I select one specific value, I want all other cells in the same row to lock.
Related categories: Visual Basic Data Processing Data Entry Excel