| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filtering throough cell color
Hi is there any way by which we can filter the rws by choosing the color of a
cell. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you change the color of the drop down button on filtering? | Setting up and Configuration of Excel | |||
| Filtering Data in ranges and changing duplicate cells to a color | Setting up and Configuration of Excel | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| filtering excel worksheet column by color of text | Excel Worksheet Functions | |||
| Excel should allow sorting and filtering based on cell color. | Excel Worksheet Functions | |||
Hybrid Mode
