Sub RS() Dim RS% RS = 2 if rs < rows.count Do Until Sheet1.Range("a" & RS) = " " Sheet1.Range("a" & RS & ":" & "c" & RS).Interior.ColorIndex = 12 RS = RS + 2 Loop end if End Sub
Sub 隔行填色() Cells.ClearFormats Dim k& k = 0 Do k = k + 2 If IsEmpty(Cells(k, 1)) Then End Range("a" & k & ":c" & k).Interior.ColorIndex = 12 Loop End Sub