Sub xx()
For i = 11 To 26
n = Cells(4 ^ 8, i).End(3).Row
ji = 0
ou = 0
Do While Cells(n, i) <> "" And IsNumeric(Cells(n, i))
If Cells(n, i) Mod 2 = 0 Then
If ji >= 3 Then Cells(n + 1, i).Resize(ji).Interior.ColorIndex = 6
ji = 0
ou = ou + 1
Else
If ou >= 3 Then Cells(n + 1, i).Resize(ou).Interior.ColorIndex = 8
ou = 0
ji = ji + 1
End If
n = n - 1
If n = 0 Then Exit Do
Loop
If ji >= 3 Then Cells(n + 1, i).Resize(ji).Interior.ColorIndex = 6
If ou >= 3 Then Cells(n + 1, i).Resize(ou).Interior.ColorIndex = 8
Next
End Sub
追é®2ãKï¼Zåï¼ä»åæä¸å¼å§å¾ä¸å¡«å
ï¼
3ãï¼ä»åæä¸å¼å§å¾ä¸å¡«å
,å½åæåä¸ä¸ªä¸å¡«å
æ¶ï¼æ¤åä¸åå¡«å
é¢è²ï¼
追çSub xx()
For i = 11 To 26
n = Cells(4 ^ 8, i).End(3).Row
ji = 0
ou = 0
Do While Cells(n, i) <> "" And IsNumeric(Cells(n, i))
If Cells(n, i) Mod 2 = 0 Then
If ji < 3 Then
ou = ou + 1
ji = 0
Else
Exit Do
End If
Else
If ou < 3 Then
ji = ji + 1
ou = 0
Else
Exit Do
End If
End If
n = n - 1
If n = 0 Then Exit Do
Loop
If ji >= 3 Then Cells(n + 1, i).Resize(ji).Interior.ColorIndex = 6
If ou >= 3 Then Cells(n + 1, i).Resize(ou).Interior.ColorIndex = 8
Next
End Sub