Not really a vba question...
Is there a way of saying (as a conditional formatting formula) "If this row number is even, then apply this formatting.
This is to accomplish getting alternate grey / white lines for ease of reading. I've done this before by using formulae in cells than getting the conditional formatting rules to refer to those formulae, but this time I can't create the extra columns to put those formulae in. So it all has to be done in conditional formatting.