Keep alternate colors on rows even while filtering data

Hello, before anything, thank you for taking your time to read this and I hope that you can help me by clarifying a doubt that I have concerning the cells formatting

Well, so here's the scenario: I'd like to work with alternate row colors (one white, the other grey). Pretty simple, right? Ok. So, the problem is that I have a filter on this sheet, so whenever I filter data, the colors get all mixed up. Being that the case, I'd kindly like to know if is there a way for Excel keep alternating the colors even when the data is filtered.


Thanks again ~

Try formatting your data as a table.

Hello dangelor, how are you doing? I'd be lying if I'd tell you that I didn't consider this possibility, I was just wondering if there wasn't an alternative mean to do it (as there's also some conditional formatting going on). Well, maybe a macro to change the TableStyle, depending on what's going on? Yeah, you've convinced me haha. Thanks!

Sometimes it's better to go with what's already available rather than reinventing the wheel, so to speak. Good luck!