How to sort rows by Colors
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 |
How to sort rows by Colors
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 |
How to sort rows by Colors
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 |
How to sort rows by Colors
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 |
How to sort rows by Colors
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 |
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com