Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|