Merging Colors Conditionally
There is an Excel file that teaches how to perform the Merging Colors Conditionally operation.
Excel Format: Merging Colors Conditionally
This workbook demonstrates merging colors conditionally using VBA macros on a 1-row data layout.
Hope it is useful.