I'm fairly inexperienced with excel, but I know how to both color a column in a table and also setup a table with alternating rows. What I am trying to do is have alternating row shading in a table with headers while also coloring the columns different color tones to help them stand out as well. Is there a way to do this as one large table rather than separate small tables for each column?
I think the only way to do this would be messing around with the opacity of the colours, I'm pretty certain you can't do that. Even if you could I'm not sure it would have the effect you are after.
Perhaps you could format the rows with the colours you want and use the border styles to make the columns stand out?