Conditional formatting for text within cell, not cell itself

[jatstern]

I'm trying to create a formula in Excel 2010 that changes the color of certain text within a cell--not the entire cell itself. Is this possible?

For example, one cell says: "Nationals vs Orioles @ Camden Yards. JS, KC."

Every time I type the initials "JS" or "KC" on my spreadsheet, I want "JS" to automatically be one color and "KC" another color. Can I create a formula that automatically changes the color of the initials? *Important: I don't want to put the initials in separate cells from the rest of the text.

I hope this makes sense. I can't find the answer in the forum, so I hope I'm not being repetitive. Thank you for the help!

 

[DRSteele]

I believe it's 'no can do.' I looked all over one of the internets once and no one has been able to solve it.

 

[Maverick_99]

A macro could be used to colour part of the text within a cell. The example below contains a for loop that loops through rows in a spreadsheet and colours the word hot in a cell in red and the word cool in a cell in blue, leaving the rest of the cell in its original colour.

It does this using the Characters object and the Font.Color property:

Excel Macros - For Loop to Colour Part of Cells

 

[jatstern]

Thank you!! I had some trouble getting it to work with your link, Maverick_99, but the coding here seemed to help:

Macro to change text color conditionally in Excel | Pixelstech.net