Editing Range Conditionally
There is an Excel file that teaches how to perform the Editing Range Conditionally operation.
Excel Professional Editing Range Conditionally
This workbook demonstrates editing range conditionally using VBA macros on a 80-row data layout.
Hope it is useful.