Colored Cells Sorter

The Colored Cells Sorter for Microsoft Excel adds the following toolbar to Microsoft Excel:

Clicking on this button displays the following dialog:

Using the first option, sort by color, allows you to sort by font color or background color.  For example

                                   Before sorting                                                  After sorting on background color 

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