How to Highlight Max and Min Values in a Pivot Chart and Format Other Values with VBA?

Originally Posted by dilipandey

Hi DMoreno,

Welcome to the forum.
Please upload a sample workbook.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi,

I uploaded the Excel file that I am using, I was able to calculate the max value and highlight (format) the label but I could not do it for the minimum value and I think it is not an "elegant" solution.

Thanks for your help.

Regards,