ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In a column with no data, only color filling, how can I filter fo. (https://www.excelbanter.com/excel-discussion-misc-queries/20621-column-no-data-only-color-filling-how-can-i-filter-fo.html)

Edmond

In a column with no data, only color filling, how can I filter fo.
 
a column with no data, only different color fillings, how can I filter for a
specific color?

I receive the information analyzed manually and specific colors indicate
different status for production orders, and I want to write me a macro for
further analysis, but the only thing different from other orders is the
color filling of the row. Can I filter a cell's color filling (shade)???
Thanks

Ron de Bruin

Hi Edmond

My EasyFilter add-in can filter on colors
See Beta version 2.1
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Edmond" wrote in message ...
a column with no data, only different color fillings, how can I filter for a
specific color?

I receive the information analyzed manually and specific colors indicate
different status for production orders, and I want to write me a macro for
further analysis, but the only thing different from other orders is the
color filling of the row. Can I filter a cell's color filling (shade)???
Thanks





All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com