Delete Row Based on Color

[trevor2524]

Quick question, Does anybody know a macro that will search all of Column A and Delete the Rows that contain the cell color Red in Column A? Thanks for any help.

[pjwhitfield]

Please Login or Register  to view this content.

will check the 1st 1000 rows, you'll need to amend the loop for your code etc

[trevor2524]

Thanks for the reply. I'm getting a compile error at

Please Login or Register  to view this content.

[Leith Ross]

Hello trevor2524,

That depends on how the color was generated (manually or conditional formatting) and which version of Excel is running the macro.

[trevor2524]

It was created by another macro. And I'm using Excel 2013.

[Leith Ross]

Hello trevor2524,

Was this macro also created using Excel 2013 or an earlier version?

[trevor2524]

It was also created using Excel 2013. Here is the code I used to find the duplicates and mark them as red.

Please Login or Register  to view this content.

[Leith Ross]

Hello trevor2524,

Have you verified your cell's color is a true red RGB(255, 0, 0) and not some custom shade of red?

Please Login or Register  to view this content.

[trevor2524]

Hello Leith,
The cells are the color that the macro sets. I don't have it running anything else against the cells. The macro you sent over almost works. For some reason its leaving one of the rows that are marked red.

[Leith Ross]

Hello trevor2524,


The cell's color is probably a custom red and not a true red RGB(255, 0, 0).

You can check by:
1) Right Click the cell and select Format Cells...
2) Click the Fill tab
3) Click the More Colors... button below the color table.

[trevor2524]

It's showing up as Red. I just ran the macro 4 more times after the initial run to remove all the red rows. So it works that way. Thanks for the help.

[Leith Ross]

Hello trevor2524,

You're welcome.