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.