Sorting may be one of the most basic features of Excel. But have you ever tried to sort different cell colors, different font colors, and even different conditional formatting icons? Today will take you to further expand the use of sorting function ideas.
Custom collation to achieve special requirements
When you have a table like this, but you want to rearrange the table according to the following rules,
What do you think you should do?
Sort by cell color
To achieve sorting by cell color, you can actually do this:
1.Select the cell you want to sort, and click Custom Sort.
2.Then sort the basis by selecting the cell color
3.And then, it’s done.
Sort by cell font color and icon style in cell
In fact, similar to the cell color sorting, as long as the custom sort, set the appropriate collation, you can sort the font color and icon style.
1.Sort by font Color
2. Sort by cell icon
