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

  • Thread starter Thread starter JVA
  • Start date Start date
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
 
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

Highlighting a block of text within a cell 3
Excel Typed text appears in wrong cell 0
Highlight changes within cell 1
Highlight specific text 1
how to count number of highlighted cells in column 5
Highlighting Text within Cell 4
How do I add cells by highlighting them? 2
Need to highlight cells in special order 0

Back
Top