Excel sorts data by color to set the method

Here's an example to illustrate:

2. We see the following picture, Windows This column has a yellow background, orange background and red font cell. We tried to get the top of the red font, followed by the orange background.
   
   Put this picture away. expand this picture
4. Select a cell in the data range to start the tab-> the edit area-> Sorting and filtering -> custom sort .
   
   Put this picture away. expand this picture
6. We select the formatted column as the keyword, and then sort by selecting the font color , the order dropdown box will have all the font color, because we have only red, so choose red.
   
   Put this picture away. expand this picture
8. We can add a secondary sorting criteria, the sort by setting the cell color , in the Order dropdown box will have this column all the cell color, we choose orange (the following two colors look like, in fact, the left side, haha!) So that the orange can be on top of the line.
   
   Put this picture away. expand this picture
10. Press . The effect is as follows:
    
    close this picture expand this picture

     
    
    (In fact, there are yellow cells in this column, and we don't sort it in our example, and you can add a sort condition to keep the yellow cells behind the orange cells)