- Sub demo()
- Dim ar, i, j, x, a, b
- a = Cells(Rows.Count, 2).End(3).Row
- b = Cells(1000, Columns.Count).End(1).Column
- ar = Range(Cells(1, 2), Cells(a, b))
- For i = UBound(ar) To 2 Step -1
- For j = 1 To UBound(ar, 2)
- n = 0
- For x = 1 To 4
- If i - x = 0 Then Exit For
- If ar(i, j) = ar(i - x, j) And ar(i, j) <> "" Then n = n + 1
- Next
- If n > 0 Then Cells(i, j + 1).Interior.ColorIndex = 3
- Next
- Next
- End Sub
复制代码 附件楼下
|