Filter

[Panos]

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



In article <[email protected]>,
"Panos" <[email protected]> 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.

[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


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



"Panos" <[email protected]> wrote in message news:[email protected]...
>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.