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 color.  For example

Before sorting		After sorting

 

If you use the second option and want to display just the yellow cells (without sorting), the following is the result:

To redisplay the hidden rows, just use the third option on the main dialog, which redisplays hidden rows.