auto filter based on color

[Alan Ku]

Is MS Excel Auto Filter able to filter based on the color?

To be specific, I have a spreadsheet marked different colors in rows, and I
would like to filter based on the color codes (rows) to sort the specific
info I need.

As far as my investigation, MS Excel 2002 don't seem to provide such
function.

 

[Nigel]

Color filtering was introduced into xl2007 . To filter using color in older
versions requires custom code, it is was not a standard function of the
autofilter.