Try the following:
Code:
Sub HighlightAnceIfNotStartOfWord()
' Search document for specified text and highlight text.
With ActiveDocument.Range
With .Find
.Text = "ance"
' .Highlight - colour - yellow if previous character if alphabetic character - otherwise turquoise.
.Wrap = wdFindStop 'stops at the end of the document
.Execute
End With
Do While .Find.Found
If .Characters.First.Previous Like "[A-Za-z]" Then
.HighlightColorIndex = wdYellow
Else
.HighlightColorIndex = wdTurquoise
End If
.Collapse wdCollapseEnd
.Find.Execute
Loop
End With
End Sub
PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.