Sub 变色() Dim i& For i = 1 To Range("A65536").End(xlUp).Row Cells(i, 1).Characters(Start:=Len(Cells(i, 1)) - 4 + 1, Length:=4).Font.Color = vbRed Next i End Sub
Sub 变色() Dim i& For i = 1 To Range("A65536").End(xlUp).Row Cells(i, 1).Characters(Start:=Len(Cells(i, 1)) - 4 + 1, Length:=4).Font.Color = vbRed Next i End Sub