Search & remove fills

waygar 

Here are some links on how to do it with filters.

Filter by font color, cell color, or icon sets

How to find and replace fill color in Excel?

or...With VBA, first what ColorIndex your corresponding cell colors correspond to.
You can output the ColorIndex like this:

Sub read()
MsgBoxRange("A1").Interior.ColorIndex 'example cell
End Sub

Then you could take out the colors like this:

sub color_out()
Dim rngRange As Range
Dim rng Cell As Range
With Sheets("Sheet1") 'Customize sheet
Set rngRange = .Range("A1:A4") 'Adjust range
End With
For Each rngCell In rngArea
If rngCell.Interior.ColorIndex = 3 _
Or rngCell.Interior.ColorIndex = 33 Then
rngCell.Interior.ColorIndex = xlNone
End If
Next rng cell
end sub

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)

Ich weiß das ich nichts Weiß (Sokrates)