|
发表于 2013-9-26 17:10
|
显示全部楼层
本楼为最佳答案
- Sub test1()
- For j = 4 To 12 Step 2
- For i = 4 To UsedRange.Rows.Count
- Select Case Cells(i, j)
- Case "No.1"
- Cells(i, j).Interior.Color = RGB(255, 0, 0)
- Case "No.2"
- Cells(i, j).Interior.Color = RGB(0, 255, 0)
- Case "No.3"
- Cells(i, j).Interior.Color = RGB(0, 0, 255)
- End Select
- Next i, j
- End Sub
复制代码 |
|