Report Row Shading

I have a sheet where I have added conditional formatting to shade every other row a color. It works fine even if I add or delete rows. I have also created a Report linked to the sheet. The Report has a filter that filters out some of the rows. Because the row shading from my Sheet flows through to my Report, I now have multiple adjacent rows that are shaded the same color in my Report as opposed to every other row. Is there a solution to this? Ideally, I would like for my Report to also have every other row shaded even when filtered. Thanks.

Best Answer

Answers