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.
