How to round Totals and Subtotals of a Pivot table

[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