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.
Advertisements