Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to the format you prefer.

To minimize errors and simulate traditional ledgers, you can format the Excel spreadsheet to highlight every other row or restrict highlighting to a single column of IDs.