I want to apply two filters to my column of data:
I want to exclude a couple of boxes in the filter list (uncheck them).
But, I also want to exclude cells that I've set to a certain fill color. However, as soon I tell it to filter by color No Fill it restores the items I've unchecked.
How do I get it to do both?
I dont believe you can
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
A filter is generally by one or the other.
To get around this, you could add a 'dummy' column. For example, if you want to filter column D, then the dummy column would simply be: =D2...
filter column D by color and then filter the dummy column by the values you want.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
I was afraid that was going to be the answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks