|
代码如下:
- Sub mycolor()
- Dim x%, i%, n%, j%, d As Object, ar, str1$, str2$, str3$
- Set d = CreateObject("scripting.dictionary")
- For x = 1 To Range("a100000").End(3).Row
- ar = Split(Cells(x, 1), ",")
- str2 = Cells(x, 1).Text
- For i = 0 To UBound(ar)
- n = InStr(1, str2, ar(i))
- str1 = Mid(str2, n, Len(ar(i)))
- For j = 1 To Len(str1)
- str3 = str3 & "-"
- Next j
- If d.exists(str1) = False Then
- d.Add str1, ""
- Else
- Cells(x, 1).Select
- ActiveCell.Characters(Start:=n, Length:=Len(ar(i))).Font.Color = RGB(255, 0, 0)
- End If
- str2 = Replace(str2, str1, str3, 1, 1, 1)
- str3 = ""
- Next i
- Next x
- End Sub
复制代码
|
|