Locking Value Conditionally
There is an Excel file that teaches how to perform the Locking Value Conditionally operation.
Excel Spreadsheet for Locking Value Conditionally
This workbook demonstrates locking value conditionally using VBA macros on a 24-row data layout.
Hope it is useful.