AutoFilter on Colour

[Dougie1]

Using Excel 2003

Hi all,

I am often emailed spreadsheets where the sender has coloured the rows in different colours to try to distinguish things. It is a constant source of perplexity to me that I cannot AutoFilter by colour (at least I have always thought that it was not possible). But I thought I would throw this one out to all you learned guys - so my question is :

Is it possible to filter by colour ??

Many thanks in advance.

D

 

[VoG]

Here's some code http://www.ozgrid.com/forum/showthread.php?t=59611

or if you have Excel 2007 http://office.microsoft.com/en-us/e...Filter by cell color, font color, or icon set

 

[Dougie1]

Brilliant VoG,

Thanks very much.

D