Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JVA JVA is offline
external usenet poster
 
Posts: 1
Default How can I highlight only some of the text within a cell in Excel?

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,358
Default How can I highlight only some of the text within a cell in Excel?

It's not possible.
--
John C


"JVA" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How can I highlight only some of the text within a cell in Excel?

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


"JVA" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
highlight cell contain the value and text with formula ratheesh Excel Discussion (Misc queries) 2 March 11th 08 06:48 AM
How do I highlight text only within a cell in Xcel? GRC Excel Discussion (Misc queries) 1 January 3rd 08 05:56 PM
No Text Highlight in Excel ?? Ean Wilson Excel Discussion (Misc queries) 10 October 15th 07 01:11 PM
highlight the word when excel finds text you are searching for Sally M Excel Worksheet Functions 7 September 21st 06 06:07 PM
Highlight cells with ctrl-click but only un-highlight one cell hagan Excel Discussion (Misc queries) 5 May 27th 05 06:45 PM


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"