auto filter based on color

  • Thread starter Thread starter Alan Ku
  • Start date Start date
A

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.
 
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.
 
Back
Top