How to sort records by color?

[Á÷À˵ÄË«Óã]

I like to distinguish different kinds of
records by different color.I also want to
sort them by color so that the records of
the same color can go side by side.Is it
possible to do that?

Any reply is appreciated.

 

[Niek Otten]

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

 

[Bob Phillips]

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

--

HTH

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