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 ***

Donald,

Running the macro recorder and editing, I get this:

ActiveCell.Characters(Start:=1, Length:=5).Font.ColorIndex = 3

hth,

Doug

"Donald Stockton" <donstock@cox.net> wrote in message
news:eA$8jFwQGHA.4900@TK2MSFTNGP09.phx.gbl...
> 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 ***

Thanks Doug,
That tells me it can be done, that will give me a good start.


"Doug Glancy" <nobodyhere@replytogroup.com> wrote in message
news:u8JE0jwQGHA.2816@TK2MSFTNGP15.phx.gbl...
> Donald,
>
> Running the macro recorder and editing, I get this:
>
> ActiveCell.Characters(Start:=1, Length:=5).Font.ColorIndex = 3
>
> hth,
>
> Doug
>
> "Donald Stockton" <donstock@cox.net> wrote in message
> news:eA$8jFwQGHA.4900@TK2MSFTNGP09.phx.gbl...
>> 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 ***
>
>

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

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

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

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

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


<edcosoft@sbcglobal.net> wrote in message
news:1141879510.494327.50870@z34g2000cwc.googlegroups.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
>

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