Filter
 

Is it possible to filter data on the basis of color of cell,text or
type of font

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

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

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 -

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

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 -