What I would suggest is that you write an expression in a new column, that should look sth like "=FIND("apple";CONCATENATE(A1;A2;A3...))" or within the whole row. Then apply the filter to this new column.
FIND will return as integer with the starting position. if it does not find the string, it will return #value, and you can use the functions to handle this error in a user-friendly manner.