Try a custom macro:
Do While Cells(Row,1) ""
If Cells(Row,1) = "Cat" or Cells(Row,2) = "Cat" Then
Row = Row + 1
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.
Keep Up with TechRepublic