A Amol Oct 2, 2007 #1 Is it possible to filter data on the basis of color of cell,text or type of font
G Guest Oct 2, 2007 #3 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.
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.
A Amol Oct 2, 2007 #4 can u give me some functions as example 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 - Show quoted text - Click to expand...
can u give me some functions as example 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 - Show quoted text - Click to expand...
D Dave Peterson Oct 2, 2007 #5 Maybe you can just use Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm