hi,
background color is formating. the filter tool filters on hard data only so
no.... you can't filter with color.
But you're not the first person to want this. Sorting by color may be an
option. unfortunately excel don't have a tool for this either.
fortunately programmers have developed a tool..... see this site.
http://www.cpearson.com/excel/sortbycolor.htm
regards
FSt1
"Lou" wrote:
I frequently get large spreadsheets (1000's of rows) where a few rows here
and there will be highlighted by changing the background color to something
other than white. Is there a way to filter the rows on background color,
analogous to the way rows can be filtered by cell contents?