Comparing Two Contents Of Two Lists

[Bomasterflex24]

Hello -

I applied a conditional formula =SUMPRODUCT(--ISNUMBER(SEARCH(Fortune_List,B2)))>0 to my list and I believe it worked. However, my first list has 45000 rows in it so I can filter by color to check and make alterations to the list.

? How can I filter by color, 45,000 rows?

Thank you

 

[Bomasterflex24]

**I cannot use the filter tool as it only checks down about 10,000 rows