Sorting in Excel 2002

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

Does anyone know if you can sort rows in Excel by color of
text or background color?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Background stays when sorting 2
How to filter rows data based on background color of individual cells 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Sorting by Color in Excel 2003 5
Sorting Cells with Conditional Formats 1
Excel 2007: Can it SUMIF( ) using color as a condition ? 5
Excel VBA - Problem with Closing Print Preview 0
VBA- Excel Programming:- 0

Back
Top