I want to format text within a cell with color in Excel

[Guest]

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.

 

[Gord Dibben]

When you go to Print Preview does the color show?

Check this out................

http://support.microsoft.com/default.aspx?kbid=833258

The fill color, the fill pattern, or the line color of a WordArt or
AutoShape object in an Office document does not change

As directed, change the High Contrast setting in Windows OS


Gord Dibben MS Excel MVP

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

 

[Zone]

I can't recreate the problem no matter how hard I try. Is the sheet
protected in anyway at all? Is there event code in the worksheet module?

 

[Ron Rosenfeld]

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

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

 

[Guest]

Hi,

I cannot reproduce your problem. It works fine on my system. I can view
different colors of edited text in print preview mode. I chenked zooming in
Print preview too.

Challa Prabhu