How can I highlight only some of the text within a cell in Excel?

J

JVA

I'd like to highlight (e.g. with yellow background) part of the text in a
cell. All I can find is highlight for the entire cell. Any ideas?
thanks, jva
 
F

FSt1

hi
no. you can't high light part of the background.
but you can high light part of the text.
in the formula bar, high light the text you want then right click the
formula bar.
notice that all you can format is the text. format to your desired format.
click ok then press enter.
this works for hard text only. will not work with formulas or numbers.
i am sure therer may be a limit to the number of formats you can have in one
cell but i don't know what it is.
regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Typed text appears in wrong cell 0
Highlighting a block of text within a cell 3
Highlight specific text 1
how do I set the arrow keys to move only the highlight not the ta 1
Highlight Changes within cell 1
Conditional Format based on sub-string 3
No Text Highlight in Excel ?? 11
Creating a formula to highlight a row of cells 3

Top