Merging Menu With Color
There is an Excel file that teaches how to perform the Merging Menu With Color operation.
Excel Template for Merging Menu with Color
This workbook demonstrates merging menu with color using VBA macros on a 1-row data layout.
Hope it is useful.