| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter
Is it possible to filter data on the basis of color of cell,text or
type of font |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter
Excel 2007.
"Amol" wrote in message oups.com... Is it possible to filter data on the basis of color of cell,text or type of font |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter
in xl2003 and earlier, not directly. I can't say for xl2007.
You can of course write a User Defined Function that can return a value that can be be used in a filter, but then that isn't doing it directly. -- Regards, Tom Ogilvy "Amol" wrote: Is it possible to filter data on the basis of color of cell,text or type of font |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter
can u give me some functions as example
On Oct 2, 10:01 pm, Tom Ogilvy wrote: in xl2003 and earlier, not directly. I can't say for xl2007. You can of course write a User Defined Function that can return a value that can be be used in a filter, but then that isn't doing it directly. -- Regards, Tom Ogilvy "Amol" wrote: Is it possible to filter data on the basis of color of cell,text or type of font- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter
Maybe you can just use Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm Amol wrote: can u give me some functions as example On Oct 2, 10:01 pm, Tom Ogilvy wrote: in xl2003 and earlier, not directly. I can't say for xl2007. You can of course write a User Defined Function that can return a value that can be be used in a filter, but then that isn't doing it directly. -- Regards, Tom Ogilvy "Amol" wrote: Is it possible to filter data on the basis of color of cell,text or type of font- Hide quoted text - - Show quoted text - -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter
Bob Phillip's site:
http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards, Tom Ogilvy "Amol" wrote: can u give me some functions as example On Oct 2, 10:01 pm, Tom Ogilvy wrote: in xl2003 and earlier, not directly. I can't say for xl2007. You can of course write a User Defined Function that can return a value that can be be used in a filter, but then that isn't doing it directly. -- Regards, Tom Ogilvy "Amol" wrote: Is it possible to filter data on the basis of color of cell,text or type of font- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
| Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| How to set multiple filter values for a filter in the page fields | Excel Programming | |||
![Amol[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
