ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Highlightng in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/80558-highlightng-excel.html)

mike?ms

Highlightng in Excel
 
Is it possible to highlight a single/multiple words within a cell?

Jim Rech

Highlightng in Excel
 
"Highlight" means different things to different people. To me it means
surround with dancing girls. So, no, that isn't possible. Sorry.

--
Jim
"mike?ms" wrote in message
...
| Is it possible to highlight a single/multiple words within a cell?



mike?ms

Highlightng in Excel
 
I like the girls! However, I meant to highlight with a color.

"Jim Rech" wrote:

"Highlight" means different things to different people. To me it means
surround with dancing girls. So, no, that isn't possible. Sorry.

--
Jim
"mike?ms" wrote in message
...
| Is it possible to highlight a single/multiple words within a cell?




Peo Sjoblom

Highlightng in Excel
 
Yes, select the word in the formula bar using mouse or shift<arrow then do
formatcells and use a coloured font or press F2 and use arrow keys and
shift<arrow to do the same


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"mike?ms" wrote in message
...
I like the girls! However, I meant to highlight with a color.

"Jim Rech" wrote:

"Highlight" means different things to different people. To me it means
surround with dancing girls. So, no, that isn't possible. Sorry.

--
Jim
"mike?ms" wrote in message
...
| Is it possible to highlight a single/multiple words within a cell?






Dave Peterson

Highlightng in Excel
 
If it's text in that cell (not a formula and not a number), then you can select
the characters you want to highlight in the formula bar and click on the
formatting (font color/font size/bold/italics) buttons--or go through
format|Cells.



??????? wrote:

I like the girls! However, I meant to highlight with a color.

"Jim Rech" wrote:

? "Highlight" means different things to different people. To me it means
? surround with dancing girls. So, no, that isn't possible. Sorry.
?
? --
? Jim
? "mike?ms" ? wrote in message
? ...
? | Is it possible to highlight a single/multiple words within a cell?
?
?
?


--

Dave Peterson

Jim Rech

Highlightng in Excel
 
Still not clear Mike. Do you want colored font or colored background? If
font is the answer is yes, if background, no.

To color part of a string (not numbers and not formulas, even if they return
a string):
-Press F2 to go into edit mode
-Select the substring within the string to color.
-Press Ctrl-1 and select the color, font type, bold, etc., that you want.

--
Jim
"mike?ms" wrote in message
...
|I like the girls! However, I meant to highlight with a color.
|
| "Jim Rech" wrote:
|
| "Highlight" means different things to different people. To me it means
| surround with dancing girls. So, no, that isn't possible. Sorry.
|
| --
| Jim
| "mike?ms" wrote in message
| ...
| | Is it possible to highlight a single/multiple words within a cell?
|
|
|




All times are GMT +1. The time now is 07:05 AM.

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