|
本帖最后由 excel助手 于 2016-1-8 13:21 编辑
Public Sub yanse()
Dim r, c, i, j, l
For r = 4 To 9
For c = 495 To 500
j = 1
For i = 2 To Len(Cells(r, c)) + 1
If Mid(Cells(r, c) & "、", i, 1) = "、" Then
l = i - j
If Application.WorksheetFunction.CountIf(Range(Cells(r + 1, 1), Cells(r + 1, 6)), Val(Mid(Cells(r, c), j, l))) > 0 Then
Cells(r, c).Characters(Start:=j, Length:=l).Font.Color = -16776961
End If
j = i + 1
End If
Next i
Next c
Next r
For r = 4 To 9
j = 1
For i = 2 To Len(Cells(r, 501)) + 1
If Mid(Cells(r, 501) & "、", i, 1) = "、" Then
l = i - j
If Cells(r + 1, 7) = Val(Mid(Cells(r, 501), j, l)) Then
Cells(r, 501).Characters(Start:=j, Length:=l).Font.Color = -1003520
End If
j = i + 1
End If
Next i
Next r
End Sub
函数公式无法解决,请用VBA解决!!.zip
(22.33 KB, 下载次数: 3)
|
|