Have a good sleep then try again.

What part or parts of Dave's pointers to assistance do you not understand or
are having a problem with?


Gord Dibben MS Excel MVP

On Fri, 30 Oct 2009 00:30:01 -0700, vlook fomula
wrote:

Hi,

i am using Excel 2003 and am tired can you help me please? for following
problem.
thanks


"Dave Peterson" wrote:

If you're using xl2007, you can apply your data|filter and sort and filter by
color.

If you're using an earlier version (xl97-xl2003), you can use Ron de Bruin's
EasyFilter to filter by color.
http://www.rondebruin.nl/easyfilter.htm

If I wanted to sort by a color, I'd use a helper column to return the colorindex
that I wanted by using a user defined function like the one Chip Pearson shares.

Chip explains it he
http://www.cpearson.com/Excel/SortByColor.aspx

vlook fomula wrote:

hI,

1. Is there any way to use filter on different color rows
2. Is there any ways to sort out rows with color wise

Regards
Zafar

--

Dave Peterson
.