Filter

[Guest]

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.

 

[JE McGimpsey]

Unless the fill colors are applied using Conditional Formatting,
programming (VBA) will be required.

See

http://www.mvps.org/dmcritchie/excel/colorsort.htm

 

[Ron de Bruin]

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