Protecting Columns Conditionally
There is an Excel file that teaches how to perform the Protecting Columns Conditionally operation.
Excel Spreadsheet for Protecting Columns Conditionally
This workbook demonstrates protecting columns conditionally using VBA macros on a 1-row data layout.
Hope it is useful.