ExcelBanter - Filtering throough cell color

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Filtering throough cell color (https://www.excelbanter.com/new-users-excel/261593-filtering-throough-cell-color.html)

Radhakant Panigrahi

Filtering throough cell color

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

Gord Dibben

Filtering throough cell color

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.

Roger Govier[_8_]

Filtering throough cell color

Hi

Only in XL2007, unless you write a macro.
--
Regards
Roger Govier

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

Dave Peterson

Filtering throough cell color

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

Radhakant Panigrahi wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 08:59 AM.