How to filter on a color of a cell

[Ussama.elghonamy]

Dear Sir

if i have a column that contains a different Background cells color
and i need to Filter using the colores

is it possible to do so provided that i'm using Excel 2003

thanks & Best regards

 

[Mike H]

Hi,

If the colour is arrived at by condirional formatting then you can put the
same condition in a helper column and filter on that or you can instal this

http://www.rondebruin.nl/easyfilter.htm

Mike

 

[MartinW]

And a couple more links

http://xldynamic.com/source/xld.ColourCounter.html#sorting

http://www.cpearson.com/excel/SortByColor.htm

HTH
Martin