How do I filter the cells based in Fill color?
 

In excel when we highlighted some of the cells with color. Finally those
unique colored cells want to filter in single step.

How do I filter the cells based in Fill color?
 

See http://www.ozgrid.com/VBA/ReturnCellColor.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Ravi" wrote in message
...
In excel when we highlighted some of the cells with color. Finally those
unique colored cells want to filter in single step.

How do I filter the cells based in Fill color?
 

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

Ravi wrote:

In excel when we highlighted some of the cells with color. Finally those
unique colored cells want to filter in single step.

--

Dave Peterson