Sorting in Excel 2002

G

Gord Dibben

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
 

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

Match table shading (color) to Visio color/Transparency 1
Changing row background from external program 0
Student & Home? 1
Printing from Word my Inserted Pictures colors are dull and lack color 0
Need help modifying code 0
How to filter rows data based on background color of individual cells 3
Background stays when sorting 2
Word for Android background colors? (corrected) 0

Top