Filter by Several Colours (leave order intact)

Handy for Adwords Accounts/Campaigns/Ad Groups

Hold down ALT & F11 to open VBA Editor

In the VBA Editor go to:
Insert:
Module

Then copy this code into the window:

Function GetColor(x As Range) As Integer

GetColor = x.Interior.ColorIndex

End Function

Create a new column next to your table of data.

Use the new function you’ve just created:

=Getcolor(A2)

This will create a colour number code for whatver colour is in cell A2.

Drag this down so that you have a colour code for each cell of column A.

You can now use the number filter to select all the colours that you want to remain in the table.