How to Sort in Excel by Color (3 Techniques)

Microsoft Excel allows us to sort data in Excel based on cell colors, font colors, and conditional formatting colors. In this article, you will learn 3 techniques to sort in Excel by color.

Technique #1: Sort in Excel by Cell Color

If you want to sort data in Excel based on cell color, follow the steps below:

❶ Click on any cell of your dataset.

❷ Go to the Data tab and click on the Sort button.

Go to the Data tab and click on the Sort button to sort in Excel by cell color

The Sort dialog box will appear.

❸ Under the Column section, select the name of the column to sort based on that column’s data.

For this instance, I’m selecting the column “Author”. Because I want to sort based on the cell colors of this column.

❹ From the Sort On section, select Cell Color.

❺ In the Order section, select the cell color that you want to keep at the top.

I’m selecting the Green color for now.

❻ After that click on the Copy Level button.

This will copy the setting that you’ve just set and create another level for you.

You can also click on the Add Level button. But that will create a brand new level and you have to tweak the settings from the scratch then.

The Sort dialog box: Sort in Excel by cell color

❼ In the copied layer, select another cell color and click on the Copy Level again.

Select another cell color and click on the Copy Level again

❽ This time, select the next cell color that you want to keep after your previous selection of cell colors.

And continue this process until you are done with all the cell colors.

❾ After making the order of all the cell colors, hit the OK button.

Now you will have your data sorted by their cell colors as in the picture below:

Sort data in Excel based on cell color

🔗 How to Sort Multiple Columns in Excel (4 Techniques)

Technique #2: Sort in Excel by Font Color

If you have data with various font colors and want to sort them according to their font colors, then proceed with the following steps.

❶ First of all, select any cell of your data table.

❷ Then go to Data > Sort.

Go to Data > Sort to sort in Excel by font color

The Sort dialog box will appear.

❸ Select the column name to sort based on its font colors in the Column section.

❹ Choose Font Color in the Sort On section.

❺ Then choose a font color from the Order section and hit the Copy Level button.

The Sort dialog box: Sort in Excel by font color

❻  Select another font color in the copied level and hit the Copy Level button again.

Select another font color in the copied level and hit the Copy Level button again

❼ Choose another font color in the copied level and continue this process until you are done choosing all the font colors.

❽ Finally hit the OK button.

Continue this process until you are done choosing all the font colors

Now your data will be sorted based on their font colors as in the picture below:

Sort in Excel by font color

🔗 How to Sort in Excel by Name (3 Techniques)

Technique #3: Sort by Conditional Formatting Icon in Excel

The usage of Conditional Formatting icons is one of the convenient ways to format data based on their properties.

Excel allows sorting data based on conditional formatting colors.

If you are looking for ways to sort your data based on the conditional formatting icons, follow the steps below:

❶ Click on any cell of your dataset.

❷ Then go to the Data tab and hit the Sort button.

Go to the Data tab and hit the Sort button to Sort by Conditional Formatting Color in Excel

❸ Select the name of the column in the Column section where the conditional formatting icons are.

❹ Then move on to the Sort On section and choose the Conditional Formatting Icon.

❺ In the Order section, choose the first conditional formatting icon that you want to put on the top.

❻ Then hit the Copy Level button.

Move on to the Sort On section and choose the Conditional Formatting Icon

❼ Select another conditional formatting icon in the copied level,

❽ Then hit the Copy Level button again.

❾ Go ahead with selecting another conditional formatting icon and continue this process until all the icons are selected.

❿ Finally hit the OK button to see the changes.

Finally hit the OK button to see the changes

Finally, you will see your data sorted as per the conditional formatting icons just like the picture below:

Sort by Conditional Formatting Color in Excel

🔗 How to Sort by Number in Excel (4 Techniques)

How to Sort Rows by Color in Excel

If you have rows with different colors, you can easily sort them based on the row colors.

Now follow the steps below to sort rows by color in Excel.

❶ First of all, click on any row to select.

❷ Then go to the Data tab and hit the Sort button.

The Sort dialog box will appear.

❸ Now select any column name in the Column section.

❹ Select Cell Color from the Sort On drop-down.

❺ From the Order drop-down, select any row color that you want to keep at the top.

❻ After that hit the Copy Level button.

❼ Then choose another row color from the Oder drop-down and hit the Copy Level button again.

❽ Choose the next row color that you want to keep after your previous selections of row colors.

Now continue this process on and on until you are done with sorting all the row colors.

❾ Finally hit the Ok command to apply changes.

After that, you will see your rows sorted by color just like the picture below:

Sort Rows by Color in Excel

🔗How to Sort in Excel by Date (3 Ways)

🔗 How to Sort Data in Excel Using a Formula (7 Formulas)

Conclusion

In this article, I’ve discussed sorting techniques in Excel based on cell color, font color, and conditional formatting icons. Feel free to comment on anything regarding the topic. I will try to respond as soon as possible.

(Visited 27 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *