|
发表于 2016-6-13 08:45
|
显示全部楼层
本楼为最佳答案
三种颜色,代码如下:- Sub xx()
- Dim rng As Range
- Set rng = Sheet1.Range("A13:C35")
- rng.Interior.ColorIndex = 0
- If rng(1, 2) >= 3 And rng(1, 3) = "" Then rng(1, 1).Interior.Color = 255
- If rng(2, 2) >= 3 And rng(2, 3) = "" Then
- If rng(1, 2) >= 3 And rng(1, 3) = "" Then
- rng(2, 1).Interior.Color = 1
- Else
- rng(2, 1).Interior.Color = 255
- End If
- End If
- For i = 3 To 23
- If rng(i, 2) >= 3 And rng(i, 3) = "" Then
- If rng(i - 1, 2) >= 3 And rng(i - 1, 3) = "" Then
- If rng(i - 2, 2) >= 3 And rng(i - 2, 3) = "" Then
- rng(i, 1).Interior.Color = 16400
- Else
- rng(i, 1).Interior.Color = 1
- End If
- Else
- rng(i, 1).Interior.Color = 255
- End If
- End If
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|