How to sort rows by using the row color as a criterion ?

S

sorabh

guyz
if i have a set of data in which all the rows fall in to say 3 colors
red green and blue and i want to sort them so that i have all reds an
all greeen and all blues in one place. Also the coloring of the rows i
not based on some value in any column, i have just colored them to m
discretion , but now want them to be together.is there any easy wa
out.........
please help
regards
sorab
 
P

Paul B

Sorabh, have a look at some coed on Chip's site here 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 2000 & 97
** remove news from my email address to reply by email **
 
Top