View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default find excel rows with a background color

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?