I sometimes like to highlight every other row as a way to make the page easier to read. The formula =mod(row(),2)=0 technique works OK until you filter or hide rows/columns. For example if you set up the formatting to shade every other row, then hide one row that was not highlighted, then you will have two highlighted rows together in the displayed view).
The following is an alternate formatting equation that (as long as there is one row/column that has no blank cells) will ignore hidden rows/columns in the worksheet. My example is for every other row assuming the first column has no blank cells: MOD(SUBTOTAL(103,OFFSET($A$1,0,0,ROW(),1)),2)=0
Keep Up with TechRepublic