Prev: ODBC
Next: Highlight Rows
From: Ron de Bruin on 7 Apr 2010 15:08
It will read all colors into the list that are in the column
But you can filter on max 5 colors

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"AccessUser777 via OfficeKB.com" <u44103(a)uwe> wrote in message news:a62cf47b839a7(a)uwe...
> This is Genius!!!! Is there a way to add a particular color to the
> EasyFilter list?
>
> Ron de Bruin wrote:
>>Hi AccessUser777
>>
>>Download EasyFilter
>>http://www.rondebruin.nl/easyfilter.htm
>>There is a color filter option in it and a option to copy to a new workbook or sheet
>>
>>Excel 2007 and 2010 gave a built-in color filter
>>
>>> Hi all. Here's my dilema:
>>> I have a spreadsheet with a lot of data (over 12k rows). Each row is colored
>>[quoted text clipped - 3 lines]
>>> up with 4 different sheets). Is this possible (cutting and pasting based on
>>> the color of the row? ) Any help is appreciated. thanks.
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-programming/201004/1
>
First  |  Prev  | 
Pages: 1 2
Prev: ODBC
Next: Highlight Rows