How to filter rows data based on background color of individual cells

  • Thread starter Danielle Schoeck
  • Start date


Danielle Schoeck

Hi everyone,

I'm new to the group and have been reading forums for a couple hours trying to find a solution for my issue, if anyone can help I'd be really appreciative!!

I have about 30 spreadsheets that I need to sort data. I'm using a Excel: Mac 2011.

Each sheet has about 100 rows and 80 columns.

I need to extract the rows that have a colored cell somewhere in the row. There are three types of colored cells: black, green, and red. The green and red have X typed in them too. The black cells have D typed in them.

Every row in the sheet has at least one cell with an X in it (colored or not).

I just need the rows with a colored cell to be extracted or filtered from all the rows without colored cells.

Hope this was enough information! Please let me know if there is anything I can do to clarify, and thanks.




Claus Busch

Hi Ron,

Am Wed, 04 Dec 2013 21:18:05 -0500 schrieb Ron Rosenfeld:
In Excel 2007 (and I am not sure if this also applies to MAC 2011) the Data filter can filter by color IF the color was applied manually. Go to the Sort & Filter tab of the Data ribbon and select Filter. One of the options will be filter by color, with a choice of font, cell or icon (or something similar.

the filter by color also works with color of conditional formatting.

Claus B.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question