Filter by Color

jdavidso · 07/23/18

Is it possible to filter a sheet by color (either font color or cell color)?

Paul Newcome · 07/23/18

It is not possible to filter by those criteria themselves, but if the colors are determined by Conditional Formatting, you can filter by the same rules.

jdavidso · 07/23/18

Thanks for the quick reply. My use case is not related to Conditional Formatting, so I'll submit a product enhancement request.

Paul Newcome · 07/23/18

Hmm... Maybe in the meantime a dropdown box as a helper column (or if there are only two types, a checkbox column) for a work around. You could then filter based off of that. I know it's one more step, but at least then you'll be able to do your filtering?

jdavidso · 07/24/18

Great workaround suggestion, thank you!

jmtrix · 12/14/18

Having a filter by color would be very helpful. I don't see a workaround for my use case. I have a list of fees (numbers) in a column and want to identify which are secured or unsecured.

Andrée Starå · 12/15/18

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (You can share them too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Filter by Color

Comments

Categories