N Norman Harker Jan 15, 2004 #2 Hi Graham! Not without a VBA approach. See: Chip Pearson: http://www.cpearson.com/excel/SortByColor.htm Provides a function for returning the color index and how to use it. -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
Hi Graham! Not without a VBA approach. See: Chip Pearson: http://www.cpearson.com/excel/SortByColor.htm Provides a function for returning the color index and how to use it. -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
