|
- Sub tt()
- Dim rng As Range
- ActiveSheet.UsedRange.Cells.Interior.ColorIndex = 0
- Set rng = Application.InputBox("请点选区域", "范围", , , , , , 8)
- If rng.Rows.Count = 1 Then MsgBox "选择范围必须大于1行": Exit Sub
- If rng.Columns.Count < 6 Then MsgBox "选择范围不能小于6列": Exit Sub
- arr = rng
- Set rng = rng(1) '左上位置
- On Error Resume Next '容错,超过边界
- For i = 2 To UBound(arr)
- x = arr(i, 1): y = arr(i, 2): Z = arr(i, 3)
- rng.Offset(i - 1).Resize(1, 3).Interior.ColorIndex = 6 '对比数,标注黄色
- For j = 4 To UBound(arr, 2) Step 3
- xyz = ""
- xyz = arr(i - 1, j) & arr(i - 1, j + 1) & arr(i - 1, j + 2)
- If InStr(xyz, x) Or InStr(xyz, y) Or InStr(xyz, Z) Then
- rng.Offset(i - 2, j - 1).Resize(1, 3).Interior.ColorIndex = 3 '符合条件的,标注红色
- End If
- Next
- Next
- End Sub
复制代码 |
|