Multiple Criteria, value and color filtering

[3nduranc3]

Hey All,

I was trying to do something, but this is not working, clearly. I would like to filter a table according to 1 column. I want to filter those values, which are named "AA" and "BB" and have a color of white or green, RBG codes are in my command.

ActiveSheet.Range("$A$1:$AB$4523").AutoFilter Field:=28, Criteria1:="=AA", Operator:=xlOr, Criteria2:="=BB", Operator:=xlOr, Criteria3:=RGB(255 _
        , 255, 255), 'Operator:=xlFilterCellColor, Operator:=xlOr, Criteria4:=RGB(146 _
        , 208, 80), Operator:=xlFilterCellColor

But its not working. How could I solve this?

Thanks in advance,

Ambrus

 

[apo]

HI..

Quick look at it.. autofilter only allows for 2 Criterias..
You may need to set up multiple separate autofilters..