Is it possible to sort via background colour of a cells ?/ Graham
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 [email protected] 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 [email protected] Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.