Is there a formula to filter for more than one colored cell?

Greetings,

I understand how to use the filter function but it appears that you can only filter one color at a time. Is there a way to filter for all colored cells? Thanks.

Hi,

You can use only one color at a time while filtering if you use "Filter By Color" option. However, you can use "SORT by color" option wherein you can chose multiple colors to sort, if that works for you.

Thanks for the reply but I was hoping for something more substantial. I have over 700 rows of data where 30 are actually colored. I wanted a formula (or whatever works) that only showed the colored rows.

I guess I should be more specific:

I have a list dataset of product numbers (p#) where the p# can occur multiple times throughout the dataset. The p# may be colored 1 of 3 ways (e.g. r,g,b). Using the multiple sort by color feature does not group similar p#'s together (which is what I need):

p1
p1
p2
p2
p3
p3

I hope that make sense.

Either I'm not filtering properly or there needs to be another function added. I sorted by color then filtered by 1,2,38,and 118. I'm still not getting the product ids to group by color using this method.

product_id count
306501 1
306501 2
311647 1
324765 1
324765 2
327806 1
327806 2
306501 38
306501 118
311647 2
311647 38
311647 118
320605 1
320605 2
320605 38