Filter By Rows, Instead of Columns

[Guzzlr]

Hello All,
I often use colored cells to filter by column. For example, column A may have 30 cells colored blue, then i can easily filter by that color to get those particular cells in Column A.
But wonder if I want to do the same filter technique with colored cells, only by Row, instead of by Column.
For example, if Row 2 has some cells colored, then how can i set a filter on Row 2, to just filter for those individual colored cells?
Thanks for the help

 

[mumps]

There is no built-in feature in Excel to filter by rows so you need a macro. This macro assumes that row 2 contains data as well a color fill.

Sub filterColors()
    Application.ScreenUpdating = False
    Dim lCol As Long, x As Long
    lCol = Cells(2, Columns.Count).End(xlToLeft).Column
    For x = lCol To 1 Step -1
        If Cells(2, x).Interior.ColorIndex = xlNone Then
            Columns(x).Hidden = True
        End If
    Next x
    Application.ScreenUpdating = True
End Sub

 

[JLGWhiz]

You cannot currehtly set an Excel filter to filter on rows based on column content. The current capability is to filter on Columns, based on row content.