How to Sort by Color in Excel?

Date:2022-4-20 Author:Sandra

Sometimes we highlight value or important data in different colors for different purposes. If we need to use color ranking or sort by color in Excel. What should we do?

There is a price table for fruits. We can see that the prices in March and April are different. So, we can get the growth rates.

How to Sort by Color in Excel?

Do you still remember how to calculate the growth rate? We’ve talked about this in one of our previous tutorials. (How to Highlight the Growth Rates in Excel?)

Growth rate =Starting value– End value/starting value.

How to Sort by Color in Excel?

Then we highlight these growth rates in three colors. Red for growth rates; green for negative growth rate and blue for zero growth.

Select the area of the growth rates and go to the Alignment settings.

Choose the Custom behind Number and type [Red]↑0.0%;[Green]↓0.0%;[Blue]0.0% in the box. Then hit Ok.

How to Sort by Color in Excel?
How to Sort by Color in Excel?

The part before is just a review. Let’s move to the next part. How to rank by selected color?

We first made a helper column like the below.

How to Sort by Color in Excel?

Then click any single cell of the Rank list to choose Sort.

How to Sort by Color in Excel?
How to Sort by Color in Excel?

You can choose the color order as you like.

How to Sort by Color in Excel?
How to Sort by Color in Excel?

Delete the Rank list at last.  You can also use this way to sort by color of the font.

How to Sort by Color in Excel?
How to Sort by Color in Excel?

See you guys next time~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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