How do I only display the rows when a specific background colour appears in any cell across multiple columns

I have a several rows in my Microsoft Excel 2010 worksheet and many columns. There is a Red background colour that appears on random cells and I want to create a way to only show those rows where there is at least one cell with a Red background colour.

Sample (The word "Red" represent the background colour of the cell):

Column:      A          B           C          D         E  .... AZ      (column range can go up to column AZ)
Row1   :      Red                                            Red
Row2   :                                      
Row3   :
Row4   :                                Red

So on a new Worksheet  I would like to see with the following output with the rows without any background colour not being shown:

Column:      A          B           C          D         E  .... AZ
Row1   :      Red                                            Red
Row2   :                                Red

If a new function is required to do this type of filtering, I do not mind creating a module in the Workbook for this to work.

Many thanks in advance