Avatar of ihatelag
ihatelag
 asked on

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
Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ihatelag

8/22/2022 - Mon
Rob Henson

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.
ASKER CERTIFIED SOLUTION
Wayne Taylor (webtubbs)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ihatelag

ASKER
Thank you so much, you are a genius Wayne!
ihatelag

ASKER
Brilliant!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck