So I got an odd request from a faculty client to have a sortable spreadsheet using the format as table option of excel, which is pretty simple stuff. What gets wonky is that they want to have half of the sheet using one color theme (gray/white) and the other using a different color theme (yellow/cream). Normally, if this was just for print I'd just manually recolor things to be looking the way it was requested but as this is a constantly accessed, and resorted, spreadsheet manual recoloring won't cut it as the every-other tinting the faculty member likes won't be there and as it gets resorted a lot, it will look ugly real fast with manual coloring.
From my searching it doesn't appear having two table themes going in the same table is particularly possible. If that's the case no worries, but it would be pretty great to get this done as requested if possible.
Anyone have any ideas or insights?