Excel - filter by searching multiple columns

[Pickers]

I want to create a filter (splicer) for an excel spreadsheet that effectively does this...

Only show the rows where the word 'blue' exists in any of 3 columns. Some rows 'blue' will be in column B, other rows blue may appear in column C....

Make sense..??
Help?

 

[Pickers]

I think a variation of this is the key. Only one time I may want to filter by blue and other time filter by red, another by green - a splicer would be nice here

 

[Pickers]

So my solution was this:-
* Create a list of colours, including "ALL" (I put this in a hidden sheet) for data validation.
* Allocated a cell above the table of data (A1) and made it data validation, where values are from the list on hidden sheet.

*Created a column after the 3 columns of "rank your fav colours"
* In this column entered:

=If(A1="all","FILTER",if(or(column1=A1,column2=A1,column3=A1),"FILTER",""))

* Hid this column (named it "apply filter")
* Added a slicer to "apply filter" column which will of course only have the option "FILTER".


Now I can select the colour I want to filter on the drop down cell A1, then force the update by pressing the slicer button "filter".

To remove filters select "all" from drop down list and apply filter.

Works a treat!!