#1   Report Post  
Posted to microsoft.public.excel.misc
moe moe is offline
external usenet poster
 
Posts: 8
Default Is this possible?

So sorry, I messed up my previous post. I would like to highlight the
background of one word only contained in a cell. For example, my cell
content is: Today is Saturday. I want the word Saturday to appear with a
green background (as if I manually highlighted it with a marker). Can anyone
tell me how to do this? Thank you!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Is this possible?

It's not possible to change the fill color this way.

But you could put a rectangle from the Drawing Toolbar over the word, remove the
border and color it green. But it's an ugly workaround.

moe wrote:

So sorry, I messed up my previous post. I would like to highlight the
background of one word only contained in a cell. For example, my cell
content is: Today is Saturday. I want the word Saturday to appear with a
green background (as if I manually highlighted it with a marker). Can anyone
tell me how to do this? Thank you!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Is this possible?

Or, just select the word Saturday in the formula bar and change it's font
color and/or size to be different than the rest of the string........

Vaya con Dios,
Chuck, CABGx3


"Dave Peterson" wrote in message
...
It's not possible to change the fill color this way.

But you could put a rectangle from the Drawing Toolbar over the word,

remove the
border and color it green. But it's an ugly workaround.

moe wrote:

So sorry, I messed up my previous post. I would like to highlight the
background of one word only contained in a cell. For example, my cell
content is: Today is Saturday. I want the word Saturday to appear with

a
green background (as if I manually highlighted it with a marker). Can

anyone
tell me how to do this? Thank you!


--

Dave Peterson



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Is this possible?

But that is the font color--not the fill color (background).

CLR wrote:

Or, just select the word Saturday in the formula bar and change it's font
color and/or size to be different than the rest of the string........

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote in message
...
It's not possible to change the fill color this way.

But you could put a rectangle from the Drawing Toolbar over the word,

remove the
border and color it green. But it's an ugly workaround.

moe wrote:

So sorry, I messed up my previous post. I would like to highlight the
background of one word only contained in a cell. For example, my cell
content is: Today is Saturday. I want the word Saturday to appear with

a
green background (as if I manually highlighted it with a marker). Can

anyone
tell me how to do this? Thank you!


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Is this possible?

Yup........that's why I suggested it as "OR"....if the font size is
increased a couple of points and the color changed to RED it makes it a
pretty good substitute for a "highlighter swipe"

Vaya con Dios,
Chuck, CABGx3




"Dave Peterson" wrote in message
...
But that is the font color--not the fill color (background).

CLR wrote:

Or, just select the word Saturday in the formula bar and change it's

font
color and/or size to be different than the rest of the string........

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote in message
...
It's not possible to change the fill color this way.

But you could put a rectangle from the Drawing Toolbar over the word,

remove the
border and color it green. But it's an ugly workaround.

moe wrote:

So sorry, I messed up my previous post. I would like to highlight

the
background of one word only contained in a cell. For example, my

cell
content is: Today is Saturday. I want the word Saturday to appear

with
a
green background (as if I manually highlighted it with a marker).

Can
anyone
tell me how to do this? Thank you!

--

Dave Peterson


--

Dave Peterson





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Is this possible?

I read the OR as another way to change the fill color--not as another
suggestion.



CLR wrote:

Yup........that's why I suggested it as "OR"....if the font size is
increased a couple of points and the color changed to RED it makes it a
pretty good substitute for a "highlighter swipe"

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote in message
...
But that is the font color--not the fill color (background).

CLR wrote:

Or, just select the word Saturday in the formula bar and change it's

font
color and/or size to be different than the rest of the string........

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote in message
...
It's not possible to change the fill color this way.

But you could put a rectangle from the Drawing Toolbar over the word,
remove the
border and color it green. But it's an ugly workaround.

moe wrote:

So sorry, I messed up my previous post. I would like to highlight

the
background of one word only contained in a cell. For example, my

cell
content is: Today is Saturday. I want the word Saturday to appear

with
a
green background (as if I manually highlighted it with a marker).

Can
anyone
tell me how to do this? Thank you!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
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



All times are GMT +1. The time now is 05:26 PM.

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

About Us

"It's about Microsoft Excel"