I've been searching for an Excel template to use as a simple checkbook register. I downloaded the account register from Microsoft's template gallery, but whenever I modify the the column headings and cell formatting, the whole worksheeet falls apart. I'm trying to build my own from scratch, but realized that I would have to use VBA to creature some of my desired features like....

Copy running "Balance" formula down entire column, but cell is "blank" if there are no values in the "debit" and "Credit" cells of that row.

Automatically shade every other row
(A2:G2)=White
(A3:G3)=Grey
(A4:G4)=White
(A5:G5)=Grey
etc.

Can someone send me a template or prehaps provide me with the VBA code to create the two funtions described above? THANKS