If you're using the different formats on different sheets, then you should be able to format each pill separately in order to give different formats. If you need different formats on the same worksheet for the same pill, then that will require some creativity. You could duplicate the field (i.e. create a calculated field which just refers back to the original value), then place both on the sheet and format them differently.

Can you provide an example of what you are trying to do? Perhaps you could attach a packaged workbook?

If the data is already from a pivot table, It'll be tricky pivoting it again. I understand what you mean by having different data types in [Pivot Field Value]. Such data type mixture is an alarm bell that shows that you have over-pivoted the data or that the data wasn't properly structured in the first place.

Can you share a dummy sample dataset? It's either you don't need to add all the fields to the pivot or you could use calculated fields to move the different data types into separate categories.