Jilani,

Have a look at the sites below for a way to do it

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

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


--
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

"JILANI" wrote in message
...
HI

PLS SHOW HOW TO SORT COLORS IN EXCEL IN DETAIL WAY