There has to a way to filter by the color of a row.
P Peo Sjoblom Feb 1, 2005 #2 Not built in, you have to either use the condition that row was coloured at first place, then use either auto or advanced filter. If that's not possible you need to creat a help column, install UDFs like these http://www.cpearson.com/excel/colors.htm How to install http://www.mvps.org/dmcritchie/excel/install.htm then use colorindex in a help column to return the index number then filter on the help column Regards, Peo Sjoblom
Not built in, you have to either use the condition that row was coloured at first place, then use either auto or advanced filter. If that's not possible you need to creat a help column, install UDFs like these http://www.cpearson.com/excel/colors.htm How to install http://www.mvps.org/dmcritchie/excel/install.htm then use colorindex in a help column to return the index number then filter on the help column Regards, Peo Sjoblom