I need help to determine what is the most efficient way to format alternate rows with a different color. I've got my entire spreadsheet formatted as desired (some cells left-justified, some cells centered, correct number of decimal places, ranges with borders set appropriately, etc.). Each cell is formatted by using the appropriate style that I create manually (e.g., LeftJustifyWithPercent, RightJustifyWith2DecimalPlaces, RightJustifyWithPercent, etc.). None of these styles specify a foreground color.
If I simply cycle through the even rows to a new foreground color to the range of cells contained within that row, the original formatting is lost. If I simply cycle through the rows and change the foreground color of the cell's style, it appears that I've actually altered the definition of the original style object, thus all cells that reference that style are set to the alternate row color.
Is there a specific order of formatting that can be applied or some tip/trick/technique that can be used without creating a separate alternate row style for each different format used within the spreadsheet? Having to create a separate style object for both row colors would be very frustrating.