Conditional formatting in row header in Matrix table.

Question

Hi all,&nbsp;How I supposed to perform a conditional formatting on a row header in Matrix table?I have two rows headers anfI want that one of them will be in specific color - please find the attached picture:&nbsp; I would like that only the tasks will be colored in blue color (for example).&nbsp;I tried to create additional column due to do thi, however it's ignored the PI row header (plese find the picture below):My desirable result supposed to be like that:Does anyone has solution to this?&nbsp;Thanks a lot!

pauldbrown · Answer

Currently we can't apply conditional formatting to matrix row headers

perkele · Answer

This looks like a Table setting, not a Matrix.In the Matrix, row headers are not available in the Cell Elements (2024).

anonymous · Answer

I solved this by going into the cell elements, and making sure my formatting measure applid to 'Values and Totals'&nbsp;

anonymous · Answer

You can do it by using Row subtotals, set the color on values background

anonymous · Answer

I have no idea why this worked, but I was really struggling to get formatting to work on the row headers. I searched all over the community and was not seeing any answers.&nbsp; I was clicking around and for some reason that I don't understand, it's working now.&nbsp;Here's what I did:Removed header row from matrixadded header row back to matrix in the bottom position of the rows container.Moved it back up to top position (header row)Voila, all of a sudden I had formatting!&nbsp;

Forum Discussion

Conditional formatting in row header in Matrix table.