How to sort rows in excel by Colors

In this post I am going to explain how to sort the rows in excel sheet by color. Excel provides an option to sort the rows in excel sheet by color.

In some large excel sheet rows we marked some important rows with different colors. If the excel sheet contain this type of important data with different colors and want to see all these imporant rows in one place then this sort by color is very useful option.

Below are the steps to do the sorting by color in excel sheet rows

Below is the Sample data with different color in excel sheet

In the Excel sheet click any single cell inside a data set.
On the Data tab, in the Sort and Filter group, click on Sort and the Sort dialog box appears. OR In the Home Page Editing group click on Sort and Filter and click on Custom Sort then the same Sort dialog box appears.

Sort by Customer Name (or any other column), sort on Cell Color and select the green color for the first level.

To add other colours then Click on 'Copy Level' three times and select the other colors. The Copy Level is show in the below screen shot.
Click Ok.

The result page is shows which are sort by the color. Please find the screen shot below.

You can also find the same sorting by color in excel in the below YouTube Link
Sort By Color in Excel