是否这个意思:
Sub find()
Dim res
With Sheet2
.Range("b:b").Clear
For i = 1 To [A65536].End(xlUp).Row
res = ""
On Error Resume Next
res = .Range("A:A").find(WHAT:=Cells(i, 1).Value, LookAt:=xlWhole).Row
On Error GoTo 0
If res <> "" Then
.Cells(res, 2).Interior.Color = RGB(156, 189, 222)
.Cells(res, 2).Value = "A"
End If
Next
End With
End Sub