Filtering

[MikeyZ]

Column A = Part numbers
Col's B, C, D, E, F lists codes.
Depending on my Cond Format, certain ones get highlited in a color or colors.

Is there any way I can have those rows that have the colors highlited in B:F be visible and make all the others be hidden?

 

[Gerald Higgins]

The approach that I would use is to filter not on colour, but on the conditions that drive the colours.

Does that make sense ?

 

[MikeyZ]

Yes thnx...