|
发表于 2016-3-30 11:03
|
显示全部楼层
本楼为最佳答案
Sub test()
Dim valueDic, addressDic, A, B, C, i, j
Set valueDic = CreateObject("scripting.dictionary")
Set addressDic = CreateObject("scripting.dictionary")
A = Sheet1.UsedRange
For i = 2 To UBound(A)
For j = 3 To UBound(A, 2)
If A(i, j) <> "" Then
valueDic(A(i, j)) = valueDic(A(i, j)) + 1
addressDic(A(i, j)) = addressDic(A(i, j)) & "," & Cells(i, j).Address
End If
Next j
Next i
A = valueDic.items
B = addressDic.items
Cells.Font.ColorIndex = 0
For i = 0 To UBound(A)
If A(i) > 1 Then
C = VBA.Split(B(i), ",")
For j = 1 To UBound(C)
Range(C(j)).Font.ColorIndex = 3 '指定字体颜色,3是红色
Next j
End If
Next i
End Sub
标记相同2.rar
(13.32 KB, 下载次数: 11)
|
评分
-
查看全部评分
|