excel表格怎么找特定的人

1.在excel如何寻找特定词

只A1内容B1标红A2内容B2标红……下vba代码实现：Sub 查找加色（）Dim countcz As Integer, countbz As Integer, tj As Integer, rgbz As String, yxrow As Integeryxrow = ActiveSheet。

Range("A65535")。End(xlUp)。

RowFor i = 1 To yxrowrgbz = CStr(Cells(i, 2)。Value)countcz = Len(Cells(i, 1)。

Value)countbz = Len(Cells(i, 2)。 Value)tj = countbz + 1 - countczIf countcz。