Excel Sorting by Pattern?
 

Is it possible to sort a spreadsheet by Rows with Patterns?

Please explain what you mean by "patterns".

"Suzi" wrote:

Is it possible to sort a spreadsheet by Rows with Patterns?

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


"Suzi" wrote:

Is it possible to sort a spreadsheet by Rows with Patterns?