How to sort by color in excel 2013

Follow the steps below to sort data by colour:

1. Select any single cell inside the data
2. Go to "Data" tab >>> Click "Sort" (Shortcut: Alt+DS)
3. Select the below in the dialog box:

    Sort by: Name (the column used to sort)

    Sort on: Cell Color (the order of color)

4. Click "Copy Level" for two times to sort with the remaining colors
5. You will get the sorted output based on sequence of colors selected on clicking OK