Conditional Formatting in Pivot Tables in RTF Template

Alex Coulthard

Summary

Conditional Formatting in Pivot Tables in RTF Template

Content

Hi,

 

I'm currently trying to conditionally format cells in a pivot table in an RTF MS Word template to change the colour of some of the headers. From what I've seen there doesn't seem to be a concrete solution. Traditional methods work in regular tables but not in pivot tables.

 

Has anybody successfully managed to this?

 

Thanks in advance.

Sketz

I've never used pivot tables but I would suppose that this will work:

Place the code <?attribute@incontext:background-color;'#YOUR_HEX_COLOR_CODE'?> inside the cell you want to format outside of any grouping tags.

Alex Coulthard

Hi,

Thanks for the reply, I have already tried this however it doesn't seem to work alongside a conditional formatting rule for the header in a pivot table.

Seems to just shade the whole row and not differentiate between the cells (not due to @row because I haven't included that)

Hopefully someone has found a solution to this at some point.

Thanks anyway

Sketz

Ohh I see... so you want different formats for single cells in your header?

Technically it could work with some "control cloumns" in your data set. Like the data shown in column 1 got an "1" in the data set.

So you could toggle the different formats based on that column.

But this becomes very complex... and after all it isn't what a pivot table should do... The formatting should be applied to the entire head in one piece.