Closing Range With Color
There is an Excel file that teaches how to perform the Closing Range With Color operation.
Excel Professional Closing Range with Color
This workbook demonstrates closing range with color using VBA macros on a 9-row data layout.
Hope it is useful.