Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filter
I have got a spreadsheet which contains several rows and columns. Is there a
way to filter one of those columns based on the fill colour of the cells? Don't want to over-engineer it so try to think of an answer that doesn't involve VBA. Many thanks in advance. |
#2
|
|||
|
|||
Unless the fill colors are applied using Conditional Formatting,
programming (VBA) will be required. See http://www.mvps.org/dmcritchie/excel/colorsort.htm In article , "Panos" wrote: I have got a spreadsheet which contains several rows and columns. Is there a way to filter one of those columns based on the fill colour of the cells? Don't want to over-engineer it so try to think of an answer that doesn't involve VBA. |
#3
|
|||
|
|||
Hi Panos
See Bob's site ot use my EasyFilter Beta Add-in version 2.1 http://www.xldynamic.com/source/xld.ColourCounter.html http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Panos" wrote in message ... I have got a spreadsheet which contains several rows and columns. Is there a way to filter one of those columns based on the fill colour of the cells? Don't want to over-engineer it so try to think of an answer that doesn't involve VBA. Many thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions |