Excel Partial text font properties

Excel Partial text font properties
0

Upvotes

Upvote

 Apr 21 2022
0 Comments 
New

I would like to be able to change the font color of a specific part of the text in a cell;
In VBA you would do something like this

 

Public Sub changeColor()

    Range("A1").Characters(Start:=7, Length:=5).Font.ColorIndex = 3

End Sub