Highlighting text WITHIN a cell string isn't standard, highlighting the cell itself is.

Update your example workbook. Include:

1) the macro as you have it so far
2) before/after examples
3) point out where things are going on if not obvious in the macro or on the sheet

Remember, we don't know what you're after unless you present the need completely.