Pivot table Conditional Formatting not working when Collapsing columns

Question

I'm applying a conditional formatting to the cells in a pivot table that turns the background color to red when the third decimal is larger than 0.

The conditional formatting formula is

=C8-ROUND(C8;2)>0

It works find when I expand or collapse the rows:

Collapsing and the format keeps applying the condition:

Collapsing again and the format keeps applying the condition:

But it doesn’t work when collapsing the columns:

• Data in “TE FW/ week 29” is 104,006 and should have a red background as the third decimal is 6.
• Same happens in Pepe/Week 29 = 64,006

Any idea of how to correct this?

Thanks,

Microsoft® Excel® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20542) 32-bit

Windows 10 Enterprise 22H2 19045.4651

Answer 1

Sorry, the answer is easy:

Trunc should be used instead of Round in the conditional formatting formula.

Else the decimal would be <0 instead of >0 when third decimal is >5