Excel 2010: Wildcards in the auto filter search

In Excel 2010, when you create an auto filter and click the arrow, a search box appears allowing you to quickly type words you are searching for. What would I type in this box to search for all cells in the column that contain both blue and green anywhere in the text.

When I Type 'Green', it shows all cells with 'Green' anywhere in the text.
When I type 'Blue', it shows all cells with 'Blue' anywhere in the text.

Now i'm trying to find all cells in a column that have both 'Blue' and 'Green' in the text. When I Type "*Green*" xland "*Blue*" it does not seem to work. I'm hoping it's as simple as me not putting in the right syntax  in the search box.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
I believe this similar topic has been discussion in this recent thread:

VBA: filter multiple data from different sheets based on a dynamic range
You can't do it with a single entry into the autofilter search but:
1. autofilter first for 'Blue' then click on the arrow again and put 'green' and tick 'add to current selection'
2. click on Text Filters, custom filter, and add two rules for 'contains', 'Green' and 'Contains', 'Blue'

the second option is easier to maintain because it shows them in one place but is limited to two filters whereas the first option can be difficult to see what you have already filtered on but can be added to many times
If you need more complex rules or wild cards then either advanced filter or VBA are the next stage

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.