Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Is there a way to programatically change the font properties (color) of
only a portion of a cells content, like maybe the first 5 characters, or maybe characters 10-15. etc D.S. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Donald,
Running the macro recorder and editing, I get this: ActiveCell.Characters(Start:=1, Length:=5).Font.ColorIndex = 3 hth, Doug "Donald Stockton" wrote in message ... Is there a way to programatically change the font properties (color) of only a portion of a cells content, like maybe the first 5 characters, or maybe characters 10-15. etc D.S. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Thanks Doug,
That tells me it can be done, that will give me a good start. "Doug Glancy" wrote in message ... Donald, Running the macro recorder and editing, I get this: ActiveCell.Characters(Start:=1, Length:=5).Font.ColorIndex = 3 hth, Doug "Donald Stockton" wrote in message ... Is there a way to programatically change the font properties (color) of only a portion of a cells content, like maybe the first 5 characters, or maybe characters 10-15. etc D.S. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Highlight what you want changed within the text on the Formula Bar. Go
to Format menu / cells / font and make your changes. I do it quite often. ed |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Highlight what you want changed within the text on the Formula Bar. Go
to Format menu / cells / font and make your changes. I do it quite often. ed |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Highlight what you want changed within the text on the Formula Bar. Go
to Format menu / cells / font and make your changes. I do it quite often. ed |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Highlight what you want changed within the text on the Formula Bar. Go
to Format menu / cells / font and make your changes. I do it quite often. ed |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
Can't do it in this particular situation, I'm trying to highlight portions
of text, and I need to do it within a procedure I'm working on. Thanks wrote in message ups.com... Highlight what you want changed within the text on the Formula Bar. Go to Format menu / cells / font and make your changes. I do it quite often. ed |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font color of cell content
While your typing, or open the cell, and in the formula bar highight
the text you want to change, then use the Format menu, cells and change the color. Return to your typing, or close the cell. What is the problem with this? You can even change the color of part of a word. ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Font color automatically when Cell Format is Percentage | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Changing color in text boxes based on content | Excel Discussion (Misc queries) | |||
Changing the font size of a drop-down box content | Excel Discussion (Misc queries) | |||
Changing Cell Font and Color Issue, | Excel Programming |