How to sort rows by Colors

[Sheikh Saadi]

hi there,

can anybody help me out to sort the rows by Colors. like I have two colored
rows Light Green and Light Yellow and some are without colors. how do i sort
them that same colors come with eachother?
--
Sheikh Saadi

[Paul B]

Sheikh, this is not a buit in function in excel, will be in the next
version, have a look here for a way to do it

http://www.cpearson.com/excel/SortByColor.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sheikh Saadi" <[email protected]> wrote in message
news:[email protected]...
> hi there,
>
> can anybody help me out to sort the rows by Colors. like I have two
colored
> rows Light Green and Light Yellow and some are without colors. how do i
sort
> them that same colors come with eachother?
> --
> Sheikh Saadi

[Bob Phillips]

See http://www.xldynamic.com/source/xld....r.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sheikh Saadi" <[email protected]> wrote in message
news:[email protected]...
> hi there,
>
> can anybody help me out to sort the rows by Colors. like I have two
colored
> rows Light Green and Light Yellow and some are without colors. how do i
sort
> them that same colors come with eachother?
> --
> Sheikh Saadi

[Sheikh Saadi]

Hi Paul,
could you please tell me where should I need to write those functions as I
am totaly new to VBA programming. or if you could then send me a sample file
in working condition at [email protected]

I will be very greatfull to you.
--
Sheikh Saadi


"Paul B" wrote:

> Sheikh, this is not a buit in function in excel, will be in the next
> version, have a look here for a way to do it
>
> http://www.cpearson.com/excel/SortByColor.htm
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Sheikh Saadi" <[email protected]> wrote in message
> news:[email protected]...
> > hi there,
> >
> > can anybody help me out to sort the rows by Colors. like I have two
> colored
> > rows Light Green and Light Yellow and some are without colors. how do i
> sort
> > them that same colors come with eachother?
> > --
> > Sheikh Saadi
>
>
>

[Paul B]

Sheikh, sent you a file to look at

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sheikh Saadi" <[email protected]> wrote in message
news:[email protected]...
> Hi Paul,
> could you please tell me where should I need to write those functions as
I
> am totaly new to VBA programming. or if you could then send me a sample
file
> in working condition at [email protected]
>
> I will be very greatfull to you.
> --
> Sheikh Saadi
>
>
> "Paul B" wrote:
>
> > Sheikh, this is not a buit in function in excel, will be in the next
> > version, have a look here for a way to do it
> >
> > http://www.cpearson.com/excel/SortByColor.htm
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Sheikh Saadi" <[email protected]> wrote in message
> > news:[email protected]...
> > > hi there,
> > >
> > > can anybody help me out to sort the rows by Colors. like I have two
> > colored
> > > rows Light Green and Light Yellow and some are without colors. how do
i
> > sort
> > > them that same colors come with eachother?
> > > --
> > > Sheikh Saadi
> >
> >
> >

[David McRitchie]

Even though you received a working file you may still want to have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Some additional examples using Chip's user defined functions or on color in general
http://www.mvps.org/dmcritchie/excel/colors.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sheikh Saadi" <[email protected]> wrote in message news:[email protected]...
> Hi Paul,
> could you please tell me where should I need to write those functions as I
> am totaly new to VBA programming. or if you could then send me a sample file
> in working condition at [email protected]
>
> I will be very greatfull to you.
> --
> Sheikh Saadi
>
>
> "Paul B" wrote:
>
> > Sheikh, this is not a buit in function in excel, will be in the next
> > version, have a look here for a way to do it
> >
> > http://www.cpearson.com/excel/SortByColor.htm
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Sheikh Saadi" <[email protected]> wrote in message
> > news:[email protected]...
> > > hi there,
> > >
> > > can anybody help me out to sort the rows by Colors. like I have two
> > colored
> > > rows Light Green and Light Yellow and some are without colors. how do i
> > sort
> > > them that same colors come with eachother?
> > > --
> > > Sheikh Saadi
> >
> >
> >