ExcelBanter - Filter by Color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter by Color (https://www.excelbanter.com/excel-discussion-misc-queries/12973-filter-color.html)

Javid

Filter by Color

Hi
how can I filter by colors in Excel?
Fallah

Bob Phillips

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

All times are GMT +1. The time now is 06:13 PM.