| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
| need funct to match data in 3 seperate spreadsheets column 1 to v. | Excel Discussion (Misc queries) | |||
| How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Linear Mode
