Posted 8 September 2017, 2:04 pm EST
I want to simulate alternate colors by column instead of by row. For consistency, I want to use the default alternating row color. Let's say we have several columns of related Import Data and several columns of related Export Data. I want to use the default alternating row color as the back color for alternating groups of column information.
1. How do I programattically retrieve the alternating row default back color
2. Is the best way to apply this color to columns creating a named style, changing the back color and applying it
3. Is the alternating row color itself a style that I can use without alternation except for applying it to columns
4. Can I apply a style to multiple columns simultaneously, for example something like Columns(2, 4).Style = myStyle
Thanks in advance for any ideas and/or suggestions!