Need to filter by two colors

Hey There,

I am trying to filter my data so that only the yellow and green rows show. I know how to filter by color using the following command:

ActiveSheet.Range("$A$4:$C$11").AutoFilter Field:=1, Criteria1:=RGB(146, _
208, 80), Operator:=xlFilterCellColor

but I don't know how to filter by multiple colors. Maybe another way around this would be to sort first by green and then by yellow and then selecting and hiding both the red and blue cells, but I don't know how to do this either. Need to find an automatic way for this process as new rows are constantly being inserted in.

Any help is greatly appreciated. Thank you

al

Thank you very much for your reply. I have been trying to get this to work but to no avail. Would you please be able to help me do so in the practice sheet I attached in this message. I would greatly appreciate it.

Thank you,

Al

practicefile.xls

I changed the color codes to match the actual colors you are using. You will note that there is a comment in the code that this is required, but it appears that you didn't make any changes.

Your data starts in row 5 but the macro started in row 2. It is also necessary to update that.

Your button is configured to run Macro2 so here is the updated code:

Please Login or Register  to view this content.