|
多套一重循环- Sub 标色()
- arr = Range("a1:j" & [a65536].End(3).Row)
- For k = 4 To UBound(arr) - 1
- x = arr(k, 2)
- For j = 8 To 10
- y = arr(k, j)
- yrr = Split(y, "-")
- For i = 0 To UBound(yrr)
- yy = yrr(i)
- xx = Mid(x, i + 1, 1)
- p = InStr(yy, xx)
- If p > 0 Then Cells(k, j).Characters(i * 5 + p, 1).Font.ColorIndex = 3
- Next
- Next
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|