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, 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" wrote in message
...
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

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

--

HTH

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


"Sheikh Saadi" wrote in message
...
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

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

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" wrote in message
...
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, 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" wrote in message
...
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

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" wrote in message
...
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

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" wrote in message ...
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

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" wrote in message
...
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