|
- Sub Macro1()
- Dim i&, n&, s&
- ActiveSheet.UsedRange.Interior.ColorIndex = xlNone
- n = 3
- For i = 4 To Range("b65536").End(xlUp).Row + 1
- If Cells(i, "j") <> Cells(i - 1, "j") Then
- s = s + 1
- If s Mod 2 Then s2 = 22 Else s2 = 36
- Cells(n, 2).Resize(i - n, 15).Interior.ColorIndex = s2
- n = i
- End If
- Next
- End Sub
复制代码 |
|