Filer By color in Excel 2003

rocker123

rocker123

Adept
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 :(
 
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....
 
Fahrenheit said:
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....
Click to expand...
Our office still has office 2003 liscense.
So need to find a soln in excel 2003 itself.
 
Back
Top