sort by colors

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

Hi, i am trying to sort data that has been identify by colors. Can it be done?
can i sort data by color ?
thank you for your attention.
 
I assume that you are wanting to use conditional formatting for this little
endeavor.

However, as far a I know there is currently no way to sort it as such.
Sorry if this wasn't the answer you were looking for.

Just so I know, are you coloring them through conditional formatting or are
you just changing the color manually?
 
One problem I can see with this option, and that is if this spreadsheet is
meant to be distributed. If you intend to distribute this among computers,
each will be required to have this item.
 
The code is within a module in the workbook so will be distributed with the
workbook.

I don't see a problem.


Gord Dibben MS Excel MVP
 
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

How to filter rows data based on background color of individual cells 1
Error Installing "ADAPTEC EZCD 4.04" 1
Excel VBA - Problem with Closing Print Preview 0
Sorting by color of font 4
Sorting with Formatting 4
Sorting a spreadsheet by strikethrough? 1
VBA- Excel Programming:- 0
Sort Question 5

Back
Top