Conditional Formatting

[#1]

Hello people!

I need help with conditional fotmatting in a calculated expression.

I have a pivot table with category, supplier, product and the price for 2 months. I need calc the variation and paint red the supplier with max variation and paint green the supplier with min variation.

Attach a example where for:

-  Category A --> Supplier B is de max and Supplier E is de Min

- Category B --> Supplier B is de max and Supplier D is de Min.

Can anyone help?

Thanks!

[lironbaram · Accepted solution]

hi

have a look at the attach example