Partial font color

S

smart.daisy

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.
 
M

Miguel Zapico

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.
 
G

Gord Dibben

Select the cell.

Hit F2 to enter edit mode.

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

Format>Cells>Font>Color>pick a color and Ok your way out.


Gord Dibben MS Excel MVP
 
Top