#1   Report Post  
Javid
 
Posts: n/a
Default Filter by Color

Hi
how can I filter by colors in Excel?
Fallah
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

You could add a helper column and determine the colorindex in that column,
and filter on that column.

A colorindex function is available at
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Javid" wrote in message
...
Hi
how can I filter by colors in Excel?
Fallah



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter by color of row Brie Excel Worksheet Functions 1 February 1st 05 07:13 PM
Filter by color of row Brie Excel Worksheet Functions 0 February 1st 05 06:59 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM
Color Code Filter indicators - Change from Blue to Red Martinson44 Excel Worksheet Functions 0 November 10th 04 04:25 AM
Select or Filter by Fill Color Wil Excel Worksheet Functions 1 November 4th 04 10:03 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"