Answers for "excel colour every other row"

excel bold alternating rows

select your rows > 
conditional formatting > 
add your own formula > 
=mod(row(),2)=1  >
select the style for chosen rows.

.................................
the formula applies the formatting to every ODD row. 
owing to the modulo (remainder) of the row number/2 = 1.