Solved

Excel Color Sorting

Posted on 2015-01-05
4
121 Views
Last Modified: 2015-01-05
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
Comment
Question by:gadsad
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
Wilder1626 earned 500 total points
ID: 40531231
0
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 40531233
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
 

Author Closing Comment

by:gadsad
ID: 40531256
thank you
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40531267
I'm glad i was able to help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question