How do I highlight text in a cell?

P

PeppiS

Is there a way to highlight specific text within a cell without having to
fill color the entire cell. I know Word has a highlighter tool, but I cannot
find one in Excel. Thanks for any information!
 
F

Frank Kabel

Hi
- select the cell
- hit F2 and in the formula bar select only the characters you want to
change (e.g. different font color)
- now goto 'Format - cells' and change the appearance
 
D

David McRitchie

Color formatting of partial contents of a cell is only available to change
the Font not the interior (background) shading (highlighting) behind selected
characters (unlike MS Word).. Also only for text constants not for formulas.
 
Top