How To Sort By Color In Excel
1. Click Data (1), and then click on sort (2).
Note: After following this step, press Add level, sorting by the same thing in column, cell color, and choose color you’d like to have on the second place. Continue until you’d add all the colors in the data, and then press ok.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References