Hide Row on Filter - May be challenging

[fbacchus]

Hi:

I am almost convinced that this cannot be accomplished or it would be difficult to accomplish. I would like to hide specific rows only when someone is filtering the data. I have several rows in my spreadsheet which I use for 'illustrative' purposes but if the user filters that data on any column, some of the 'illustrative' rows get included in the return set. I don't want this to happen - just the valid rows and not the 'illustrative' rows. The illustrative rows are in 'yellow' but I can tag them with a value (e.g. "1"), if need be as criteria for exclusion.

Thoughts?

frank

 

[BarryL]

hopefully this is the right yellow

whatever column the yellow is in change as needed

Sub colour()
Dim LR As Long, i As Long
LR = Range("a" & Rows.Count).End(xlUp).Row
Application.ScreenUpdating = False
For i = LR To 1 Step -1
    If Range("a" & i).Interior.ColorIndex = 6 Then Rows(i).Hidden = True
Next i
Application.ScreenUpdating = True
End Sub