How do I filter the cells based in Fill color?

[Ravi]

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

 

[ozgrid.com]

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

 

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