Results: Excel will sort the red cells to the top of the report.
Figure 608 The red cells come to the top.
Additional Details: Using the context menu as described here works fine if you need to sort by only one color. If you used cells of several different colors and want to sort them in a particular order, you need to select Data, Sort to open the Sort dialog. Then, for the first sort level, you choose Quantity in the Sort By dropdown, Cell Color from the Sort On dropdown, and green from the Order dropdown.
You set the next sort level by clicking the Copy Level button and then choosing yellow from the Order dropdown. You click Copy Level for each additional color you need to specify.
Figure 609 Four levels for one column.
If you have many colors in a column, you might use several sort levels to specify how to sort the first column.
Additional Details: You can also sort by font color or cell icon. Amazingly, sorting by color will even work if your colors have been assigned through conditional formatting.