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