|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
参与一下。。。- Sub ykcbf() '//2024.2.22
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("我的表")
- .Cells.Font.ColorIndex = 0
- r = .Cells(Rows.Count, 4).End(3).Row
- arr = .Range("d3:d" & r)
- For i = 1 To UBound(arr)
- s = CStr(arr(i, 1))
- d(s) = ""
- Next
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .Range("a1:a" & r)
- For i = 3 To UBound(arr)
- st = CStr(arr(i, 1))
- b = Split(st, ",")
- For x = 0 To UBound(b)
- s = b(x)
- If Not d.exists(s) Then
- l = InStr(.Cells(i, 1), s)
- With .Cells(i, 1).Characters(l, Len(s)).Font
- .Color = RGB(255, 0, 0) ' 红色
- End With
- End If
- Next
- Next
- End With
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|