How to set colour of a special character

**one8421** · 08-20-2010, 10:37 AM

I have a VBA formula (in italic) below:

Please Login or Register  to view this content.

What I want to show this when I display this symbol in cells is a red heart symbol but A in normal black colour. How can this be achieved?

**JBeaucaire** · 08-20-2010, 10:41 AM

Like so:

Please Login or Register  to view this content.

Please edit your post above and put [code] tags around the code, like I've shown here.

**one8421** · 08-20-2010, 10:50 AM

Thanks for your quick reply. This can solve some of my problem. But I am actually looking at wherever I paste the value "HeartSymbol" anywhere in the spreadsheet, it will appears in red colour. It is doable?

**JBeaucaire** · 08-20-2010, 11:04 AM

I've shown you the syntax for changing the color of a single character in a text string. You have to name the cell, then starting position in the string and the number of characters you are formatting the color.

You will need to adapt that technique to your other possible scenarios. The technique shown changes the first character to red.