Forum Discussion
Table Formatting - Centered Values, Different Color Column Headers
Did you ever figure out this issue? I'm looking to do the same thing, create column headers with different colors in a table, and cannot figure it out. I have seen it done but can't quite arrive at the solution
I found a round-about way of doing this. Use the specific column to centre all the values and colour the headers (and values) with the colour. Then add conditional formatting of the background colour to the values.
In this, use the gradient format style, and colour both ends of the gradient white.
This will then override the background colour of the values in the specific column field.
I can't believe this isn't an innate feature, but here we are.
Thanks for the work round. It would be nice if Microsoft added alignment options on the Values field rather than having to apply conditional formatting.
