Hi All. I created a macro to insert some text, format the text upto the ":" in BOLD, and the rest back to Normal text.
It appears to work fine until I type on the end of the text which keeps defaulting back to to BOLD again??
Any ideas?

With ActiveCell:
    .FormulaR1C1 = "=""GSM " & Date & " Actions for "" &[[Allocated Worker]]&"": There was a bear who lived in a tree"""
    .Value = .Value
    
    With .Characters(Start:=1, Length:=InStr(1, .Value, ":", vbTextCompare)).Font

        .FontStyle = "Bold"

    End With
    With .Characters(InStr(1, .Value, ":", vbTextCompare), 2000).Font
 
        .FontStyle = "Regular"

    End With
End With