Is it possible to sort a spreadsheet by Rows with Patterns?
P Peo Sjoblom Jun 3, 2005 #3 You mean that you want pattern colours sorted together, you can use a UDF to and a help column to get the colorindex and then sort by that or a macro Chip Pearson has both on his site http://www.cpearson.com/excel/colors.htm http://www.cpearson.com/excel/SortByColor.htm Regards, Peo Sjoblom
You mean that you want pattern colours sorted together, you can use a UDF to and a help column to get the colorindex and then sort by that or a macro Chip Pearson has both on his site http://www.cpearson.com/excel/colors.htm http://www.cpearson.com/excel/SortByColor.htm Regards, Peo Sjoblom
