Sorting/filtering by Color

[fgwiii]

I know that what I am suggesting sounds like I am "smacked", but logically it
should be possible to sort/filter by the cell color because adding color to a
cell does change the properties of the cell.

My question is has anyone ever done this and if so can you tell me how?

Thanks

Fred

 

[Ron de Bruin]

I have a add-in that have a option to do this that you can try
http://www.rondebruin.nl/easyfilter.htm

In Excel 2007 it is a built-in option

 

[Michael.Tarnowski]

I know that what I am suggesting sounds like I am "smacked", but logically it
should be possible to sort/filter by the cell color because adding color to a
cell does change the properties of the cell.

My question is has anyone ever done this and if so can you tell me how?

Thanks

Fred

Hi Fred,
in addition to Ron's addin have a look at
http://www.cpearson.com/excel/SortByColor.aspx
http://www.ozgrid.com/VBA/Sort.htm

Have a nice day
Cheers
Michael