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.

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.

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.