R Ravi Apr 28, 2010 #1 In excel when we highlighted some of the cells with color. Finally those unique colored cells want to filter in single step.
In excel when we highlighted some of the cells with color. Finally those unique colored cells want to filter in single step.
D Dave Peterson Apr 28, 2010 #3 You could update to xl2007. This feature was added with that version. And if you're using xl2003 or below, you can try Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm Or you could use a helper cell in each row that would return the color of the cell you want. Chip Pearson shows how: http://www.cpearson.com/Excel/colors.aspx Look for: Colors In A Cell Or Range If you're new to macros: Debra Dalgleish has some notes how to implement macros here: http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.)
You could update to xl2007. This feature was added with that version. And if you're using xl2003 or below, you can try Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm Or you could use a helper cell in each row that would return the color of the cell you want. Chip Pearson shows how: http://www.cpearson.com/Excel/colors.aspx Look for: Colors In A Cell Or Range If you're new to macros: Debra Dalgleish has some notes how to implement macros here: http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.)
