Matrix format column group header

Question

Hi,&nbsp;I've seen variations of a solution for this, but nothing that specifically addresses this issue. Any help would be much appreciated!&nbsp;I have a simple matrix:This is the data:&nbsp;I need to set the background of the "First Time" group to blue and the background of the "Returning" group to yellow.&nbsp; I can use the&nbsp;Cell Elements formatting to set the background color of the values, but it does not apply to the column header or column group header.&nbsp;&nbsp;How can I conditionally set the column headers and column group headers so it looks like this?&nbsp;&nbsp;

anonymous · Accepted Answer

Hi,&nbsp;joyhackett&nbsp;
From my understanding, you can modify the header color individually through the Specific column. Please note that this is manual.

I thought of a possible solution. You can try to put a text box/rectangle with appropriate transparency on top of the Matrix, and set the conditional formatting color of this text box/rectangle to achieve the effect you want.

&nbsp;
&nbsp;
&nbsp;
How to Get Your Question Answered Quickly
Best Regards
Jianpeng Li
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Matrix format column group header

2 Replies

Related content

Matrix Row Conditional Formatting

Matrix formatting

Matrix columns formatting

Formatting Matrix Visuals

Formatting Column headers in matrix