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.

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.

--

Regards,
Nigel
(E-Mail Removed)



"Alan Ku" <Alan (E-Mail Removed)> wrote in message
news:F3539A7B-E6FB-469F-80B3-(E-Mail Removed)...
> 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.