How to Sort Data by Color in Excel?

Last Updated : 03 Mar, 2022

Sorting Data By Color allows us to segregate the data cells of a specific color. There can be many ways to sort by color like sorting by Cell color, sorting by Font color, etc. We can also add multiple levels in sorting data by color. Sorting by Color makes analysis very easy and time-saving.

Sort by Cell Color

Given a dataset of geeks for geeks courses and its fees. In the given data set the rows are colored with yellow whose fees are greater than 1000 rupees. Try putting all the cells at the top whose fees are greater than 1000 rupees.

Data-set

Steps for sorting data by color

Step 1: Select the cells in which you want to apply to sort.

selecting-cells

Step 2: Go to Data Tab and you will find an option called Sort. Click on the Sort option and a pop-up appears.

pop-up-appearing

Step 3: The pop-up has many different options.

Add Level: This option helps us add different levels based on the priority.
Delete Level: It helps delete the added levels.
Copy Level: It allows us to copy different levels for reordering the priority.

Add-delete-copy-level-options

Step 4: Go to Sort by column and select on which basis you want to sort the data. Generally, sorting by color does not require this but by default, we need to fill this field.

selecting-column

Step 5: Sort on is the most important field and tells on which criteria you want to sort the selected cells either sort by cell color or sort by font color etc. Selecting sort by cell color for this example.

selecting-sort-by-cell-color

Step 6: After selecting sort by color. Set the priorities for all colors.

Setting-priorities-for-color

Step 7: The next field tells whether you want to position all the colored cells on top or bottom. Selecting on Top for current data Set.

Positioning-cells-after-sorting

Step 8: Hence all the cells with yellow color come at the top.

Yellow-cells-at-top

Sort by Font Color

Given a data Set of geeks for geeks Courses and their Fees. All the articles whose prize is greater than 1000 rupees are written in red font color. Try locating all the cells at the top whose fees are greater than 1000 rupees.

Data-set