The Colored Cells Sorter add-in for Microsoft® Excel® allows one to sort rows based on color. It is compatible with Microsoft Excel 2010-2021 and Office 365.
Its main dialog displays the following options:
Using the first option, sort by color, allows you to sort by font color or background color. For example
The Colored Cell Sorter allows you to sort the colored cells so that they are at the top or at the bottom.
If you use the second option, show or hide rows based on color, the following dialog appears that gives you options to show or hide cells based on background color and/or font color:
If you want to display just the yellow cells (without sorting) in the previous data example, the following is the result:
To redisplay the hidden rows, just use the third option on the main dialog, which redisplays hidden rows.