higlight the section you want to colour every other row in and in conditional
formatting type

If formula is =MOD(ROW(),2)=0



"Shanfrog" wrote:

Is there a quick way to pick and highlight every other row in an excel
spreadsheet?