I haven't tested the formatting you're applying, but could you not create a pivot table style?