make every third row in this list grey code example
Example: 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.