Dear All, Is it possible to sort data in column by colour of text,if yes how ??
M melvinc74 Feb 20, 2004 #1 Dear All, Is it possible to sort data in column by colour of text,if yes how ??
F Frank Kabel Feb 20, 2004 #2 Hi one way: - create a helper column - Use the UDF Colorindex from Bob Phillips/Harlan Grove which can be found in the following thread: http://tinyurl.com/2u22g - in your helper column add the formula =Colorindex(A1) - copy this down Now you can sort with this helper column
Hi one way: - create a helper column - Use the UDF Colorindex from Bob Phillips/Harlan Grove which can be found in the following thread: http://tinyurl.com/2u22g - in your helper column add the formula =Colorindex(A1) - copy this down Now you can sort with this helper column
G Gord Dibben Feb 21, 2004 #3 mel How did the text get colored? By Conditional Formatting or manually? If by CF, you may be able to sort based on the conditions. If not, you must use VBA. See Chip Pearson's site for SortByColor VBA code. http://www.cpearson.com/excel/SortByColor.htm Gord Dibben Excel MVP
mel How did the text get colored? By Conditional Formatting or manually? If by CF, you may be able to sort based on the conditions. If not, you must use VBA. See Chip Pearson's site for SortByColor VBA code. http://www.cpearson.com/excel/SortByColor.htm Gord Dibben Excel MVP
