Protecting Rows With Color
There is an Excel file that teaches how to perform the Protecting Rows With Color operation.
Excel Spreadsheet for Protecting Rows with Color
This workbook demonstrates protecting rows with color using VBA macros on a 17-row data layout.
Hope it is useful.