Select the cell and in the edit bar you can then select (highlight)
some of the text with the mouse and format how you wish, eg bold,
different colour, different background colour, different font/font size
etc.
Hope this helps.
Pete
Don Guillett - 06 Feb 2006 14:19 GMT
This will NOT work in a formula. Works only if all text.

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
> Select the cell and in the edit bar you can then select (highlight)
> some of the text with the mouse and format how you wish, eg bold,
[quoted text clipped - 4 lines]
>
> Pete
Boe - 06 Feb 2006 15:45 GMT
Thanks
> This will NOT work in a formula. Works only if all text.
>
[quoted text clipped - 6 lines]
>>
>> Pete
Boe - 06 Feb 2006 15:44 GMT
Thank you
> Select the cell and in the edit bar you can then select (highlight)
> some of the text with the mouse and format how you wish, eg bold,
[quoted text clipped - 4 lines]
>
> Pete
I know that it may be smacking me in the face but I don't see an option for
highlight - I am running Excel 2003 - I do see the cell fill and bold and
underline but nothing for text highlight.
> I'd like to highlight just some of the text in a cell - not the entire
> thing.
>
> Thanks
Pete_UK - 06 Feb 2006 16:37 GMT
You can click anywhere in the edit bar and the cursor will be placed at
that point. Then you can hold the mouse button down while moving the
cursor, or you can hold <SHIFT> down while pressing the <arrow> keys
(more precise). Once you have higlighted the text you want in this way,
just click on the formatting features you wish (colour, bold etc).
Hope this helps.
Pete
Boe - 06 Feb 2006 17:11 GMT
Ahh - I see why my question is not clear. I want to format text as
HIGHLIGHTED - like the markers you used in college to bring attention to a
particular sentence or term.
> You can click anywhere in the edit bar and the cursor will be placed at
> that point. Then you can hold the mouse button down while moving the
[quoted text clipped - 5 lines]
>
> Pete
Pete_UK - 06 Feb 2006 17:20 GMT
Well, you want something like a pale yellow or pale green background
colour. Select your portion of the text as described above, then select
the background colour you want for this part of the text. You might
want to set the foreground as bold to stand out more.
Pete
Boe - 09 Feb 2006 07:39 GMT
How do I select the background color for that portion of the text?
> Well, you want something like a pale yellow or pale green background
> colour. Select your portion of the text as described above, then select
> the background colour you want for this part of the text. You might
> want to set the foreground as bold to stand out more.
>
> Pete
Pete_UK - 09 Feb 2006 11:35 GMT
I've just tried to do it and discovered that Excel will not allow you
to change the background colour for a portion of the text - sorry for
misleading you. You can, however, change foreground colour and
bold/italic/underline effects etc, so you will have to emphasise your
partial text this way.
Hope this helps.
Pete
Boe - 10 Feb 2006 01:56 GMT
At least I know why I was having such a hard time figuring out how to do it.
> I've just tried to do it and discovered that Excel will not allow you
> to change the background colour for a portion of the text - sorry for
[quoted text clipped - 5 lines]
>
> Pete