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

  • Thread starter Thread starter sorabh
  • Start date Start date
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
 
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 **
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Sort rows by colors 6
Changing color of a row 3
Alternate Row Coloring 6
Access Remove rows based on multiple fields 2
How to reset every other row color after sorting 2
sorting rows of data 7
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top