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

On Thu, 15 Apr 2010 10:29:02 -0700, Radhakant Panigrahi
wrote:

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