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
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.
If it is conditional then you could probably create a helper column to check for the condition and then filter on that.