Google Sheets. CF Alternating rows in filtered view.

[GolfNut39]

Sorry I looked everywhere but can not find the answer.

Google Sheets.

I have a hockey team with numbers 1-98 down Column A but only have around 23 numbers (players) used per year so I have the spreadsheet filtered by another column F that indicates if they are Active with a "Y" for yes.

So my spreadsheet is always filtered by Column F and when I use conditional formatting to alternate colors on the sheet of course it is a mess as it really is doing the original unfiltered sheet.

My question is there a way to get it to alternate colors of the rows in filter view.

As always appreciate your time...GN