Sorry, English isnt my mother tongue, hope youll be able to understand my
question anyway.
I have a sheet with four columns of data. Three of them contain numbers and
the last one contains a word like the example bellow.

In Out Pending Name
1 3 2 Andrew
5 3 7 Mike
3 2 4 Andrew
2 7 1 Mary
4 5 1 Andrew

Now, if I want to quickly find all rows containing the word €œAndrew€� I go to
Edit, click Find and click replace and type Andrew into the €œFind what€� space
and Andrew into the €œreplace with€� space. After that I format the fonts to
desired color and press ok and then click €œreplace all€� and all Andrews get
colored or whatever I chose to format.
How do I go from here if I want to have only the €œAndrew€� rows? Is there any
why to do that?

Thank you very much for helping me. I appreciate it a lot!

M. Larsen