Excel conditional formatting error

[Imi_Jay]

Hi there,

I have a pivot table with different rows. I applied a traffic light with 5 colours on a value column via conditional formatting.

It works fine on desktop. Just after I add it to MS teams , and when I collapse the columns conditional formatting disappears.

Original data file has 5 parent rows. So when I upload it to MS teams and after I collapse rows, conditional formatting remains in the first 5 rows only.

Adding test data set and more :

Data setConditional formattingPivot table before uploading to MS teamsPivot table on MS teams and after collapsed

Is it a bug or am I doing something wrong ? Thanks for the help!