We help IT Professionals succeed at work.

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

85 Views
Last Modified: 2017-03-08
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
Comment
Watch Question

Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
What is creating the red background? Conditional Formatting, or random cell filling?

If it is conditional then you could probably create a helper column to check for the condition and then filter on that.
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Thank you so much, you are a genius Wayne!

Author

Commented:
Brilliant!