Filer By color in Excel 2003

[rocker123]

Is there any possible way to filter by color in excel 2003 ?

Any VBA code which could solve my purpose.

Was searching for some codes, but none of them were generalised i.e. we had to enter the color code for each color in order to filter by that color.

Or codes which were sorting by color rather than filtering by color.

Im searching for a script which could automatically detect the color in that particular column, and then i could filter by that color in that particular column without modifying the VBA script everytime i need to filter by a particular color.

Help needed

 

[indy1811]

I know this wont be of any use to you but there is an option in Excel 2007 to filter by color. You can probably send it across to somebody who has that version, ask him to filter it, save it in 2003 format, and then send it back to you....

 

[rocker123]

I know this wont be of any use to you but there is an option in Excel 2007 to filter by color. You can probably send it across to somebody who has that version, ask him to filter it, save it in 2003 format, and then send it back to you....

Our office still has office 2003 liscense.
So need to find a soln in excel 2003 itself.

 

[thenvk]

Try this
VBA Express : Excel - AutoFilter Column by Color

 

[rocker123]

Try this
VBA Express : Excel - AutoFilter Column by Color

Already tried this one.
For using this code, everytime i need to change the color code in accordance with the color used.

 

[Roxtin]

May be old link but see if it helps

Easy Filter : Filter,copy,Delete and Hide