AutoFilter out cells by colour

[j4ttlife]

Hi all,

I'm trying to filter out certain cells in a column that I have filled as green. I only want to see the cells that are not green.

Normally I filter out by using the following code change the colour of certain cells and it works okay:

To change the colour of certain cells I use:

Cells(i, 22).Interior.Color(38, 201, 218)

and then to filter out I use:

my_sheet.Range("A1").AutoFilter field:=22, Criteria1:=RGB(38, 201, 218), Operator:=xlFilterCellColor

However, this time I have change the cell colours using:

cell.Interior.ColorIndex = 4

This time I have used a ColorIndex instead of the color codes, but I'm unsure how to filter these out.

 

[Fluff]

If you record a macro whilst manually filtering on that colour, the macro will show you the RGB value

 

[j4ttlife]

If you record a macro whilst manually filtering on that colour, the macro will show you the RGB value

Thanks Fluff. I managed to resolve that issue using the macro recorder.

However, I made a mistake in my original code that I posted above.

The code above actually filters out all the cells that are NOT equal to RGB(38, 201, 218).

Is it possible to filter out cells that ARE equal to RGB(38, 201, 218) ?

 

[Fluff]

You can filter for "No Fill" but not to exclude only a certain colour.

 

[j4ttlife]

You can filter for "No Fill" but not to exclude only a certain colour.

Sorted, grateful for the help!

 

[Fluff]

You're welcome & thanks for the feedback.