Prev: Excel Jululian
Next: Macro Help - Jacob Skaria has previously been helping
From: Ravi on 28 Apr 2010 02:48
In excel when we highlighted some of the cells with color. Finally those
unique colored cells want to filter in single step.
From: ozgrid.com on 28 Apr 2010 04:14
See http://www.ozgrid.com/VBA/ReturnCellColor.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Ravi" <Ravi(a)discussions.microsoft.com> wrote in message
news:EDF851F4-4A3B-4BEF-BCBE-07197B9EC352(a)microsoft.com...
> In excel when we highlighted some of the cells with color. Finally those
> unique colored cells want to filter in single step.

From: Dave Peterson on 28 Apr 2010 07:47
You could update to xl2007. This feature was added with that version.

And if you're using xl2003 or below, you can try Ron de Bruin's EasyFilter
addin:
http://www.rondebruin.nl/easyfilter.htm

Or you could use a helper cell in each row that would return the color of the
cell you want.

Chip Pearson shows how:
http://www.cpearson.com/Excel/colors.aspx

Look for: Colors In A Cell Or Range

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Ravi wrote:
>
> In excel when we highlighted some of the cells with color. Finally those
> unique colored cells want to filter in single step.

--

Dave Peterson
 | 
Pages: 1
Prev: Excel Jululian
Next: Macro Help - Jacob Skaria has previously been helping