How to round Totals and Subtotals of a Pivot table

[nasa]

Dear community,

I am trying to apply conditional formatting on pivot table’s columns based on a pre-defined (sales) target value. I have created a new calculated field to round Sales values up to two decimals. The condition is getting applied on single values, but not for Totals and Subtotals as shown on screenshots.

On the example below, I would like to round the Total sales value for the Food category from 99.778 to 99.78, so that the cell will get green colored. Do you have any suggestions, how to implement such a formatting?

[nasa]

Additional screenshots:

[Deep]

Hello Nasa,

Welcome to the QS community.
could you follow the old post here below ? May be this is similar to your case pertaining to formatting

Conditional formatting not working for min and max value in the between range

[Screenshot 2023-08-29 at 10.06.57 AM] Value 1 in the screenshot should be light green. Instead, its white because its not picking up the background color. My condition is if values are between 1 and 1.99, then use green as the background color. 1 and 1.99 particularly are still white. Looks like between doesn’t include the min and max values in the condition.

Let us know if it helps.
Cheers,
Deep

[nasa]

Thank you Deep. The post helped me to solve the issue. I have reduced the sales target by -0.005. Now, values like 99.778 get colored in green.