Filtering cells in excel by format

Posted by Amit on January 30, 2002 7:30 AM

Hi,
Is it possible to filter cells in a column in excel by the format. For eg. I want to filter out all the cells in a particular column which has background colour of red. Can this be done.

Pls help

Amit

Posted by Juan Pablo G. on January 30, 2002 8:08 AM

I created a UDF

Juan Pablo's UDF at 14070.html

To Count ocurrences by Colour. So, you may use it doing this. In an empty cell, put the background color you want (I'm using G1), my data is in A1:E13. So, in F2:F13 (Row 1 holds my headings) i put this formula

=CountShades(A2,$G$1)>0

You can now filter by Column F, where TRUE's are rows that are Red in Column A.

Juan Pablo G.