Conditional formatting and coloring rows

[cynlewman]

I have a very large dataset of 92000 rows. I have a business where I sell digital PDF files. The dataset customer orders. Every row has information about a single product purchase including date, customer name, customer email address and the product purchased. I'm trying to find every row that has a specific product purchased. In this case the product purchased is: Big John Farm Tractor + Trailer + Combine (2 PDF ePlan Downloads). My goal is to highlight every row that contains this product (row K). Then I'd like to sort the data by row color. My goal is to quickly find all email addresses that have purchased this product so I can quickly save a txt file with just those email addresses.
I've followed directions for conditional formatting with highlighting rows and creating a new rule but it never works. My formula is: =$K990236="Big John Farm Tractor + Trailer + Combine (2 PDF ePlan Downloads)" with the goal of highlighting the entire row with a cell color.

 

[mikerickson]

Rather than going through Conditional Formatting, you could make your range a table and use filtering to find all the rows with that product.
(Also, sort by color only works on the base cell color, not on colors that result from Conditional Formatting)

 

[cynlewman]

Can you please expand on your answer? Is filtering the same as Find and Replace? My end goal is to quickly grab all the email addresses that have purchased that product and I don't know how to accomplish that.

 

[mikerickson]

If set up a filter on column A and have it filter on "cat" all the rows that have "cat" in column A will be shown and the other cells hidden.
The easiest way for you to learn this would be to make a copy of your work workbook and play with the filter options on the copy.

 

[cynlewman]

Thank you, Mike! That worked for perfectly. I really appreciate your help. - Cynthia

 

[Peter_SSs]

Also, sort by color only works on the base cell color, not on colors that result from Conditional Formatting

FYI: That is not so for me. Provided the colour is exactly the same, filtering by that colour shows rows coloured directly and/or via CF.