Hi

If you need to retain the formula, the answer is no, but if the
formula can be transformed to a 'value' with Copy/PasteSpecial, it
can be done as below:

Sub ColorLastLetter()
ActiveCell.Copy
ActiveCell.PasteSpecial xlPasteValues
ActiveCell.Characters(Start:=Len(ActiveCell),
Length:=1).Font.ColorIndex = 3
End Sub

Regards,
Per

On 23 Sep., 20:05, David wrote:
Say, for example I have worksheet formula =3*4&" ABC"
12 ABC displays in the cell
The cell font color is formatted as black
Is there a VBA way to have the displayed character "C" in red font for
example?
My guess is "no"
I'm just hoping someone will suprise me
Thanks