D Diane Jul 30, 2003 #1 Does anyone know if you can sort rows in Excel by color of text or background color?
G Gord Dibben Jul 30, 2003 #2 Diane Depends upon how the cells received their color format. If by using Conditional Formatting, the same conditions could be used to sort. If manually colored, you will need VBA. See Chip Pearson's site for details and code. http://www.cpearson.com/excel/SortByColor.htm Be sure to read the NOTE: on Conditional Formatting at bottom of page. Gord Dibben Excel MVP - XL97 SR2 & XL2002
Diane Depends upon how the cells received their color format. If by using Conditional Formatting, the same conditions could be used to sort. If manually colored, you will need VBA. See Chip Pearson's site for details and code. http://www.cpearson.com/excel/SortByColor.htm Be sure to read the NOTE: on Conditional Formatting at bottom of page. Gord Dibben Excel MVP - XL97 SR2 & XL2002
