|
参与一下。。。
- Sub ykcbf() '//2024.4.24
- Set reg = CreateObject("VBScript.Regexp")
- With Sheets("test")
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 11)
- .Cells.Interior.ColorIndex = 0
- With reg
- .Global = False
- .Pattern = "AAA.csv|BBB.csv|CCC.csv|DDD.csv|AAA.csv-2|BBB.csv-2|CCC.csv-2|DDD.csv-2"
- End With
- For i = 2 To r
- If arr(i, 1) <> Empty Then
- If arr(i, 11) >= 1.3 Then
- .Cells(i, 1).Resize(1, 11).Interior.ColorIndex = 3
- Else
- If reg.test(arr(i, 1)) Then
- .Cells(i, 1).Resize(1, 11).Interior.ColorIndex = 8
- End If
- End If
- End If
- Next
- End With
- End Sub
复制代码
|
|