ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 - Text Shading (https://www.excelbanter.com/excel-discussion-misc-queries/63042-excel-2003-text-shading.html)

Peppermint

Excel 2003 - Text Shading
 
Word 2003 has a feature whereby you can select part of the text in a cell and
apply shading to only that text. Does Excel have such a feature - or
something similar? I need to put black shading on a few words of text in a
cell, but not on ALL the text in that cell.

Chip Pearson

Excel 2003 - Text Shading
 
You can do this if the cell contains text. You can't do it if the
cell contains a formula. Select the cell, then highlight the
appropriate characters in the formula and apply the formatting.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Peppermint" wrote in
message
...
Word 2003 has a feature whereby you can select part of the text
in a cell and
apply shading to only that text. Does Excel have such a
feature - or
something similar? I need to put black shading on a few words
of text in a
cell, but not on ALL the text in that cell.




SVC

Excel 2003 - Text Shading
 
If by shading you mean highlighting, the answer is no. You can select a word
(or words) in the cell, click Format Cell, and this will bring up the Font
tab. You can then change the font, font style, size, underline, and color,
but no highlighting.

"Peppermint" wrote:

Word 2003 has a feature whereby you can select part of the text in a cell and
apply shading to only that text. Does Excel have such a feature - or
something similar? I need to put black shading on a few words of text in a
cell, but not on ALL the text in that cell.



All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com