Filter by color of row
 

There has to a way to filter by the color of a row.

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

"Brie" wrote:

There has to a way to filter by the color of a row.