|
发表于 2023-5-14 16:38
|
显示全部楼层
本楼为最佳答案
- Sub demo()
- [f:f].Interior.ColorIndex = 0
- Set Rng = [f65535]
- Set d = CreateObject("Scripting.Dictionary")
- a = [a1].CurrentRegion
- For i = 1 To UBound(a)
- If a(i, 4) = "√" Then d(a(i, 5)) = 1
- Next
- For i = 1 To UBound(a)
- If d(a(i, 5)) Then Set Rng = Union(Rng, Cells(i, 6))
- Next
- Rng.Interior.Color = &HB4E0C6
- End Sub
复制代码 祝順心,南無阿彌陀佛!
|
|