Dinamic search filter data table

Not really
i would like something that search (and dynamically filer) in a data table any rows that contains the "search string" in any cell.

Senza titolo-3.jpg
look at this better example

May be any simple solution will be welcome.

the picture is from
http://datatables.net/release-datata...bootstrap.html
not from excel
thanks

Hi, go to cell F4 and enter a couple letters (eg. "al", "ha".. etc.), then press Enter. The rows will be advance filtered for any name in Column A that contains the string you entered.

This is the code in Sheet1:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("F4")) Is Nothing Then
    Range("A9:C70").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
    Sheets("Criteria").Range("A1:C2"), Unique:=False
End If


End Sub

Here it is...
Hope should be useful... tell me if someone enhance this sample in some way...
Elenco.xls

Used Excel 2007 a short VBA code and conditional formatting take a look

Private Sub TextBox1_Change()
If Range("A1") <> "" Then
Range("A1").Select
    Selection.AutoFilter
    ActiveSheet.Range("$C$2:$H$800").AutoFilter Field:=1, Criteria1:=RGB(247, 150, 70), Operator:=xlFilterCellColor
TextBox1.Activate
Else
ActiveSheet.AutoFilterMode = False

TextBox1.Activate
End If

End Sub