mix font attributes of text returned from cell formula

  • Thread starter Thread starter David
  • Start date Start date
D

David

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
 
For a formula cell no.. or other wise

Range("B11").Characters(Start:=Len(Range("A1")), Length:=1).Font.ColorIndex
= 3

If this post helps click Yes
 
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
 
Back
Top