Filtering throough cell color

[Radhakant Panigrahi]

Hi is there any way by which we can filter the rws by choosing the color of a
cell.

 

[Gord Dibben]

In 2007 you can.

Before that you must use VBA unless the cells are colored due to Conditional
Formatting.

Then you filter on the condition.


Gord Dibben MS Excel MVP

 

[Roger Govier]

Hi

Only in XL2007, unless you write a macro.

 

[Dave Peterson]

And if you're using xl2003 or below, you can try Ron de Bruin's EasyFilter
addin:
http://www.rondebruin.nl/easyfilter.htm