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?

 

[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

 

[Bob Phillips]

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

--

HTH

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

 

[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 (e-mail address removed)

I will be very greatfull to you.

 

[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

 

[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