1. Highlight every other row in Excel using conditional formatting (Using Table Styles P1- 6)

2. Highlight every other row in Excel using conditional formatting (MOD Formula P6- 14)

 

See attached PDF Doc