Splitting Range With Color
There is an Excel file that teaches how to perform the Splitting Range With Color operation.
Excel Solution: Splitting Range with Color
This workbook demonstrates splitting range with color using VBA macros on a 65536-row data layout.
Hope it is useful.