I have one cell with text "new! Balance sheet tab". I want partial text"new!"
showing red color, the other part "blance sheet tab" remaining blue. Is there
a way to realize that? Thanks.

You can do that editing the cell, highlighting the part you want in a
different colour in the formula bar ("new!" in this case) and selecting the
font color in the formatting toolbar.
I have tried it with Excel 2003, I don't know if it would work in other
versions.

"smart.daisy" wrote:

I have one cell with text "new! Balance sheet tab". I want partial text"new!"
showing red color, the other part "blance sheet tab" remaining blue. Is there
a way to realize that? Thanks.

Select the cell.

Hit F2 to enter edit mode.

Select "new!" in formula bar or in cell.

FormatCellsFontColorpick a color and Ok your way out.


Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 10:37:02 -0700, smart.daisy
wrote:

I have one cell with text "new! Balance sheet tab". I want partial text"new!"
showing red color, the other part "blance sheet tab" remaining blue. Is there
a way to realize that? Thanks.

Thank you! It works. I tried all complicated methods. It's a neat method.

"Gord Dibben" wrote:

Select the cell.

Hit F2 to enter edit mode.

Select "new!" in formula bar or in cell.

FormatCellsFontColorpick a color and Ok your way out.


Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 10:37:02 -0700, smart.daisy
wrote:

I have one cell with text "new! Balance sheet tab". I want partial text"new!"
showing red color, the other part "blance sheet tab" remaining blue. Is there
a way to realize that? Thanks.