auto filter based on color
 

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.

auto filter based on color
 

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




"Alan Ku" <Alan wrote in message
...
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.