Changing colorindex of a part of cell contents

[villy]

Hi Gurus,

Pardon me for my ignorance..
Just want to know if it is possible to change colorindex only part of a cell contents.
Ex:
In spreadsheet, I can have more than one font color for my cell contents.
In VBA can I do that, how?

What I want:
I have a macro that generates a resulf from a formula (concatenate) that I need to have two different colorindex.

Please share with my curiosity.
Thanks in advance.

 

[mikerickson]

One apply rich text (multiple formats in the same cell) to cells with constants, but if the cell holds a formula, the result is all in the same format.

The macro recorder can give you the syntax to format the Characters property of a range.

 

[villy]

Thanke Mike,

After I post this issue I came to realized to use a Macro Recorder. It is now working fine.
Thanks anyway