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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> Donald,
>
> Running the macro recorder and editing, I get this:
>
> ActiveCell.Characters(Start:=1, Length:=5).Font.ColorIndex = 3
>
> hth,
>
> Doug
>
> "Donald Stockton" <[email protected]> wrote in message
> news:[email protected]...
>> 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


<[email protected]> wrote in message
news:[email protected]...
> 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