Filtering Excel table based on conditional formatting in multiple columns

[glennpc]

I have an Excel table, where for a few different columns I have conditional formatting turning some cells to appear in bold red text. If I only did this on one column, I could then run a filter on the color, and it would eliminate the records that don't have that color-- but it only works on one column at a time. I can't figure out a way to tell Excel to filter out all records where the color is not present in ANY of the columns. Anyone know how to do that?

 

[Sinon]

I'm not sure about filtering it like that but it can be sorted anyway. select your entire table, go to DATA->SORT. then choose the column to sort by. In the "Sort on" select "Font color". In the "Order" field select black or Automatic, depending on what the font color is in the non red cells and choose "On top". You then have to add a level for your next column by clicking "Add Level". Repeat for all the columns and your desired results (non red font) should be the first in the list.

 

[glennpc]

Thanks! This sorting might do the trick.