Thread: How to filter rows data based on background color of individual cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default How to filter rows data based on background color of individual cells
Hi Ron,

Am Wed, 04 Dec 2013 21:18:05 -0500 schrieb Ron Rosenfeld:

In Excel 2007 (and I am not sure if this also applies to MAC 2011) the Data filter can filter by color IF the color was applied manually. Go to the Sort & Filter tab of the Data ribbon and select Filter. One of the options will be filter by color, with a choice of font, cell or icon (or something similar.

the filter by color also works with color of conditional formatting.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote