Filter Columns by Color

[DougStroud]

How can I filter multiple columns by color?

 

[Yongle]

If the colours are the result of conditional formatting then consider Advanced Filter
https://www.contextures.com/xladvfilter01.html
- adapt the rules applied in CF to create the formulas required by advanced filter

If the colours are manually applied then you probably need VBA

 

[Peter_SSs]

If the colours are the result of conditional formatting then consider Advanced Filter

That is a choice but AutoFilter can still be used manually or by VBA if the colours are there by Conditional Formatting so that would probably be easier.

The only time you might need to use the rules that applied the CF would be if you had the same colour applied both by CF and directly and you wanted to filter one and not the other - highly unlikely I think.

 

[Yongle]

@Peter_SSs
- I should have stated in my reply that I assumed that the question was being asked because auto filter by colour had been found inadequate.

 

[Yongle]

@DougStroud

The detail of how you are trying to filter would help us address your specific problem

 

[Peter_SSs]

@Peter_SSs
- I should have stated in my reply that I assumed that the question was being asked because auto filter by colour had been found inadequate.

You could be right, perhaps even because the excel version is old and doesn't even have that option.

It could be though that a macro just to apply multiple colour filters is being requested.

So little information in the question it is all a guess really. Hopefully the OP will provide enough information to allow a suitable suggestion.