{"id":555,"date":"2022-11-14T15:39:09","date_gmt":"2022-11-14T15:39:09","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=555"},"modified":"2024-04-12T13:20:34","modified_gmt":"2024-04-12T13:20:34","slug":"how-to-sort-data-by-color-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-sort-data-by-color-in-excel\/","title":{"rendered":"How to Sort data by Color in Excel?"},"content":{"rendered":"

Sort Data by Color in Excel is a powerful feature that allows you to organize and analyze data visually. It goes beyond traditional sorting methods by using color to prioritize tasks, track statuses, and categorize data effortlessly. This function helps uncover patterns, trends, and insights that may have gone unnoticed. By utilizing this feature, you can enhance data organization and reporting, making your Excel worksheets more efficient and clear. Whether you’re managing projects, checking data quality, or improving data visualization, Sort Data by Color in Excel empowers you to extract meaning from color-coded information.<\/p>\n

Given a dataset of student attendance. In the given data set the rows are colored with green whose attendances are greater than 85%. Try putting all the cells at the top whose attendance are greater than 85%.<\/p>\n

\"Sort<\/p>\n

Steps for sorting data by single color:<\/p>\n

Step-1: <\/strong>Select the cells you want to apply the sort to. (Cells A2 to B11 in the example).<\/p>\n

\"Sort<\/p>\n

Step 2:<\/strong> Select the Data Tab and then select the Sort option. Choose Sort from the menu. This will bring up the Sort dialog box.<\/p>\n

\"Sort<\/p>\n

Step 3: <\/strong>Make sure “My Data has headers” is chosen in the Sort dialog box. You can leave this option unchecked if your data doesn’t include headers.<\/p>\n

\"Sort<\/p>\n

Step 4:<\/strong> There are multiple choices in the pop-up.<\/p>\n

Add Level: Depending on the priority, we can add various levels using this option.<\/p>\n

Delete Level: It aids in erasing the extra levels.<\/p>\n

Copy Level: It enables us to duplicate various levels in order to reorganize the priority.<\/p>\n

\"Sort<\/p>\n

Step 5:<\/strong> Select the basis on which you wish to sort the data under Sort by column.<\/p>\n

\"\"<\/p>\n

Step 6: <\/strong>Select “Cell Color” under “Sort On” to arrange your cells according to the color of their backgrounds.<\/p>\n

\"Sort<\/p>\n

Step 7: <\/strong>Select the color you wish to retain at the top or bottom of the list by clicking the “Order” drop-down menu.<\/p>\n

\"Sort<\/p>\n

Step 8: <\/strong>Choose where you want to put the cells with the chosen color by clicking the drop-down menu next to this one. You have two choices: “On Top” and “On Bottom.”<\/p>\n

\"Sort<\/p>\n

Step-9:<\/strong> Click OK. Result outlined below:<\/p>\n

\"Sort<\/p>\n

How to Sort by Multiple Color in Excel?<\/strong><\/h2>\n

Given a dataset of Students attendances. In the given data set the rows are colored with green whose attendances are greater than 80% and red whose attendance are below 80%. Try putting all the cells at the top whose attendances are greater than 80%.<\/p>\n

\"Sort<\/p>\n

Steps for sorting data by Multiple color: <\/strong><\/p>\n

Step-1: <\/strong>Select the cells you want to apply the sort to. (Cells A2 to B11 in the example).<\/p>\n

\u00a0<\/strong>\"Sort<\/p>\n

Step 2:<\/strong> Select the Data Tab and then select the Sort option. Choose Sort from the menu. This will bring up the Sort dialog box.<\/p>\n

\"Sort<\/p>\n

Step-3: <\/strong>Select “Attendance” from the “Sort By” drop-down menu. This is the column that we intend to use to sort the data.<\/p>\n

\"Sort<\/p>\n

Step-4: <\/strong>Go to the ‘Sort On’ drop-down menu and select Cell Color.<\/p>\n

\"Sort<\/p>\n

Step-5: <\/strong>Pick the first color you want to use to sort the data from the ‘Order’ drop-down. It will display each and every color found in the dataset. Choose green.\"Sort<\/p>\n

Step-6: <\/strong>Choose your first fill color and retain On Top for the Order value.<\/p>\n

\"Sort<\/p>\n

 <\/p>\n

Step-7: <\/strong>In the panel’s upper left corner, click the Add Level button. This will result in the addition of another sort order rule.<\/p>\n

\"Sort<\/p>\n

Step 8:<\/strong> Select the basis on which you wish to sort the data under Sort by column.\"Sort<\/p>\n

Step-9: <\/strong>Go to the ‘Sort On’ drop-down menu and select Cell Color.<\/p>\n

\"Sort<\/p>\n

Step-10:<\/strong> Select the second color you wish to use to sort the data in the ‘Order’ drop-down. It will display each and every color found in the dataset. Choose Red.<\/p>\n

\"Sort<\/p>\n

 <\/p>\n

Step-11:<\/strong> Choose On-Bottom from the second drop-down menu under Order.<\/p>\n

\"Sort<\/p>\n

Step-12:<\/strong> Click OK. Result outlined below:<\/p>\n

\"Sort<\/p>\n

How to sort data by font color?<\/strong><\/h2>\n

Steps for sorting by font color: <\/strong><\/p>\n

Step-1: <\/strong>Select the cells you want to apply the sort to. (Cells A1 to B11 in the example).<\/p>\n

\"Sort<\/p>\n

Step 2:<\/strong> Select the Data Tab and then select the Sort option. Choose Sort from the menu. This will bring up the Sort dialog box.<\/p>\n

\"Sort<\/p>\n

Step-3: <\/strong>Select “Attendance” from the “Sort By” drop-down menu.<\/p>\n

\"Sort<\/p>\n

Step-4: <\/strong>Go to the ‘Sort On’ drop-down menu and select Font Color.<\/p>\n

\"Sort<\/p>\n

Step-5: <\/strong>Pick the red color to sort the data from the ‘Order’ drop-down.<\/p>\n

\"Sort<\/p>\n

\u00a0<\/strong><\/p>\n

Step-6: <\/strong>Choose \u2018On Top\u2019 for the Order value.\"Sort<\/p>\n

Step-7:<\/strong> Click OK. Result outlined below:<\/p>\n

\"Sort<\/p>\n

How to bring back original order of the data?<\/strong><\/h2>\n