Pivot table formatting

[Matthew112]

hi i have inserted a sample file where i get macros to do automatic pivot table number formatting. The macro is turned on by right clicking on a pivot table field and selecting the toggle button. Now when you insert new fields the number formats get applied automatically. The macro uses the number format from the first row.
I use different formats in the same column and was wondering if it was possible to manipulate the code with a lookup and count function to display different formats in the same pivot field.