How to give every other row a certain background color?

[Szyfrow]

Hi, does anyone know a way to give every other row (for instance every odd-numbered row) a certain background color, leaving the other rows without background colour? Thanks in advance!

[AliGW]

Have a look here: https://support.office.com/en-gb/art...ad=GB&fromAR=1

[YasserKhalil]

Hello
Follow these steps
001.png
002.png

[AliGW]

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Lsxtrkiller]

If you wanted to do it with VBA something like this would work its a bit faster than the conditional formatting.

Please Login or Register  to view this content.