Thread: filtering
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default filtering

No but you could use a helper column with values bases on colour of cells of
interest then sort by helper column.
Chip has lots on colours at http://www.cpearson.com/excel/colors.htm
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
Is it possible to filter rows based on cell formatting ?

Eg. Filter based on certain color fill .

Thanks