Notes for Excel

Formatting

Accounting format is best, this shows zero values as blank,

$_(\* #,##0.00_);_(\* (#,##0.00);;_(@_)

For conditionally highlighting every other row, if they have contents, here's the formula.

=AND(MOD(ROW(REF),2),NOT(ISBLANK(REF)))

Conditionally highlihgting every other row regardless is

=MOD(ROW(REF),2)

Fancy Formulas

If you're looking to sum numbers by column or by row for a dynamic array, BYCOL and BYROW is the formula you're looking for.

Stacking arrays is VSTACK or HSTACK, you'll get a bunch of errors if you stack mismatched arrays though.

The new line Char # is

=Char(10)