Sort the table data by the font color in the Excel cell

sort the table data by the font color in the Excel cell

The product name listed in the following figure has four different colors, sorted according to the color sequence you want, such as "gray-green-blue-red".

1. Select any cell in the table, switch to the Data tab, and in the Arrange and filter group, click the Sort button.

2, pop-up "Sort" dialog box, set the main keyword for the product name, sorting according to the font color. We now click the Drop-down button to the right of the color in the order to display all the colors that appear in the table, select Gray, and arrange it at the top, and then add the criteria.

3, now added a column, we set the secondary keyword for the product name, sorted by font color, the order is green at the top, and then add conditions.

4, continue to increase the conditions, we set the secondary keyword for the product name, sorting according to the font color, the order is red at the bottom, OK.

5, finished, students come to learn how to implement Excel data by font color sorting method bar.