Reply to Message

paofficer
Try a custom macro:

Sub CatDog()
Row=1
Do While Cells(Row,1) ""
If Cells(Row,1) = "Cat" or Cells(Row,2) = "Cat" Then
[desired action]
End If
Row = Row + 1
Loop
End Sub

Hint: If you don't know how to write the action you want Excel to do, just record it as a new macro. Then cut and paste in Tools, Macros, Visual Basic Editor.