|
本帖最后由 CheryBTL 于 2013-8-24 08:05 编辑
wszbd 发表于 2013-8-21 17:01
能否再加个VBA:让奇行一个都没有红色单元格的显示为淡蓝色。就像
再增加了个条件来判断是否整行都没有符合条件的数据即可,至于具体的颜色,可以将65535改为想要的颜色即可。- Sub aa()
- Dim ar
- Dim i As Integer, j As Integer, k As Integer, MaxRow As Integer, temp As Integer
- Application.ScreenUpdating = False
- MaxRow = [C65536].End(3).Row
- ar = Range("C4:R" & MaxRow)
- ReDim Re(1 To UBound(ar), 1 To 16)
- For i = 2 To UBound(ar) Step 2
- For j = 1 To 16
- temp = 1
- For k = 0 To 9
- If Application.IsNumber(Application.Find(k, ar(i, j))) Then
- If Application.IsNumber(Application.Find(k, ar(i - 1, j))) Then
- Cells(i + 3, j + 2).Interior.Color = 255
- temp = 0
- Exit For
- End If
- End If
- Next k
- Next j
- If temp = 1 Then Range("A" & i + 3 & ":R" & i + 3).Interior.Color = 65535
- Next i
- Application.ScreenUpdating = ture
- End Sub
复制代码 |
|