Today we will read on this page how to do sorting by color in Excel VBA?
Click any single cell on the data set – on the Data tab, in the Sort and Filter group, sort -> Sort by last name (or any other column), sort by cell color (you can see the font color and cell )) Icon), and select the green color for the first level -> click ‘copy level’ twice and select the second color -> Click OK
How to Sorting by Colour in Excel VBA