In the old days, the Sort dialog box in Excel only had 3 levels. However, with a bit of planning, you could sort Excel data by 4 columns or more, and once you learned that trick, life was good. Or at least it was sort of good. 😉
In Excel 2007, the Sort dialog box is much fancier, and you can include up to 64 sorting levels.
I've never needed anywhere near that many – 5 or 6 fields is plenty for most tables that I've had to sort.
按颜色排序 (Sort By Colour)
Another new feature in Excel 2007 is the ability to sort by cell or font colour, or by cell icon.
If you have different colours in a column, you can choose one to show up at the top or bottom of a sorted list.
If you used conditional formatting to add cell icons, such as traffic lights, you can sort by those icons.
To put the colours or cell icons in a specific order, you can add the same field multiple times in the Sort dialog box, and choose a different colour or cell icon for each sorting level.
This won't be too difficult if you have only a few colours in the list, but will be more challenging if you have lots of colours.
The list on my worksheet, that was previously sorted by date, is now sorted by the colours, in the order that I selected above. Yellow isn't in the Sort level specifications, so it appears at the bottom of the list.
按颜色排序，风险自负 (Sort By Colour At Your Own Risk)
Even though you can sort by colour now, I wouldn't recommend it. I've seen too many rainbow coloured Excel worksheets, where nobody can remember what the colours mean. Is yellow good? Is blue bad? Is there a colour code somewhere?
即使您现在可以按颜色排序，我也不推荐。 我看过太多彩虹色的Excel工作表，没人能记住颜色的含义。 黄色好吗？ 蓝色不好吗？ 某处有颜色代码吗？
I'd rather add another column in the worksheet, and put a number code or text comment there. So, instead of marking the overdue accounts with a red fill colour, type "Overdue" in another column, or use a formula to calculate which accounts are overdue.
Or, instead of highlighting the customer names that you want to send an email to, type an X in an Email column.
Then, you can sort or filter the Overdue accounts or the Email column, to focus on the rows of interest.
您是否按颜色排序？ (Do You Sort By Colour?)
Maybe I'm missing something, and the feature is working well for you. Some people must have asked for the feature, since they added it to Excel 2007.
也许我缺少一些东西，并且该功能很适合您。 自从将功能添加到Excel 2007以来，某些人肯定已经要求使用该功能。
In your Excel worksheets, do you ever sort by colour? In what kind of lists or situations is it most helpful for you? _______________
在Excel工作表中，您是否按颜色排序？ 在哪种列表或情况下，它对您最有帮助？ _______________