Can I filter by color ?
Hi, I would like to know how if it's possible to filter by color.
Answers
-
I'm not sure if this is what you are talking about or not, but its not possible to filter by a conditionally formatted row or cell color.
I'd consider writing a formula that adds a flag or an RGB symbol into your sheet based on the same criteria your conditional formatting checks by using an IF formula. Then filter by that flag or symbol.
-
it's basic excel functionality