这个可以消除单词空格不规范情况,缺少单词仍无法解决,但已经满足楼主的题目要求了:
Sub TEST()
Dim Arr2()
Arr1 = Split(Range("a3"), " ")
Arr = Split(Range("b3"), " ")
For I = 0 To UBound(Arr)
If Arr(I) <> "" Then
K = K + 1
ReDim Preserve Arr2(0 To K)
Arr2(K) = Arr(I)
End If
Next
For I = 0 To UBound(Arr1)
If Arr1(I) <> Arr2(I + 1) Then
S = InStr(Range("B3").Value, Arr2(I + 1))
l = Len(Arr2(I + 1))
Range("B3").Characters(Start:=S, Length:=l).Font.ColorIndex = 3
End If
Next
End Sub