How do I sort data in excel by color?

[Guest]

Sorry, English isn’t my mother tongue, hope you’ll 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

 

[Norman Jones]

Hi M,

Look at the auto filter feature.

See Debra Dalgleish's tutorial at:

http://www.contextures.com/xlautofilter01.html

You might also wish to look at Ron de Bruin's EasyFilter addin which can be
freely downloaded at:

http://www.rondebruin.nl/easyfilter.htm

 

[Guest]

THANK YOU VERY MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ron de Bruin's EasyFilter is KING!!

You cannot imagine how many hours of work you saved me and WILL save me.
Thank soooo much!!

M. Larsen

 

[Ron de Bruin]

Glad you like it