Formatting Text With Color
There is an Excel file that teaches how to perform the Formatting Text With Color operation.
Excel Source: Formatting Text with Color
This workbook demonstrates formatting text with color using VBA macros on a 26-row data layout.
Hope it is useful.