Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

Excel Color Sorting

I have a large Excel table (10000 lines, 15 rows)

Some lines has been colored in red, others in blue and others not colored and I want to sort the Table according to colors
So I will be able to delete or move all red or blue lines together

Is it possible to sort an Excel table according to the color of the line?

thank you
0
gadsad
Asked:
gadsad
  • 2
1 Solution
 
Wilder1626Commented:
0
 
Rgonzo1971Commented:
Hi,

Since excel 2007, it is easy

On the Data tab, click Sort
Sort by your col, sort on Cell Color (or Font Color and Cell Icon), and select the color for the first level.
Click 'Copy Level'and select the other color if necessary.
 Click OK.

Regards
0
 
gadsadAuthor Commented:
thank you
0
 
Wilder1626Commented:
I'm glad i was able to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now