On Tue, 14 Aug 2007 06:52:01 -0700, Horse crazy <Horse
wrote:

I have a cell with several words in the color black, but I want to highlight
one of those words in red. While in the cell, I format the work using the
formatting function and while I'm editing the cell the formatting looks like
it will take place. However, when I exit the cell, I lose the formatting.


Is the text the result of a formula? If it is, you will not be able to do what
you are attempting.

You can only "differentially format" a text string. This can be done in a VBA
macro if you want to.
--ron