Handy for Adwords Accounts/Campaigns/Ad Groups
Hold down ALT & F11 to open VBA Editor
In the VBA Editor go to:
Then copy this code into the window:
GetColor = x.Interior.ColorIndex
Create a new column next to your table of data.
Use the new function you’ve just created:
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.