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