Getting Text With Color
There is an Excel file that teaches how to perform the Getting Text With Color operation.
Excel-Based Getting Text with Color
This workbook demonstrates getting text with color using VBA macros on a 8-row data layout.
Hope it is useful.