How do I filter the cells based in Fill color?

R

Ravi

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

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.)
 
Top