Formatting and pivot table question

[Mr_Phil]

Is there a way to conditionally format within a pivot table to change the font and size? I tried it and the font was greyed out. So I am assuming the answer is no. But, I am hoping for a workaround.

Our company has part numbered items. To make the part number scannable you have to add an asterisk at beginning and end then change the font to a barcode font. Easy enough in a regular range or table. Easy enough to do by hand in a pivot table. But it would be best if the PT "knew" to change the font if it is bracketed by asterisks. Anyone have any ideas? Thank you for looking and hope everything falls into place for you in all things.

 

[Alex Blakenburg]

What is your pivot table actually doing ? Can you achieve the same result using Power Query ? If you can then you can apply the conditional formatting the PQ outputs.

 

[Mr_Phil]

What is your pivot table actually doing ? Can you achieve the same result using Power Query ? If you can then you can apply the conditional formatting the PQ outputs.

Hi Alex. The PT shows the number of items and part number to issue to a technician during a weekly top off. I used to just generate pick sheets one at a time. Then I fooled around and created a pivot table and realized that I could generate pivot tables based on the report filter of the tech name. It's great. Except that everytime I update the PT some items are formatted right and some are not. I have gone thru the "source" pivot and applied the formatting. It's hit or miss if the "children" get it or not. I could do it with a macro I'm sure. But, I am trying to avoid VBA if possible.

I am still VERY wet-behind-the-ears on power query. So I will look at that just to learn something new.

 

[Alex Blakenburg]

If you are getting inconsistent formatting, can you show us an image of what you mean pointing out what you want and what you don't want.
If you change the data for the image make sure the data type is still the same and representative.

 

[Mr_Phil]

If you are getting inconsistent formatting, can you show us an image of what you mean pointing out what you want and what you don't want.
If you change the data for the image make sure the data type is still the same and representative.

Heh. That is easy since I have not yet got a solution figure out But, I did bust out the PQ on another project and am having loads of fun. Here is a typical bit of the main pivot table before I go in and manually change the font to a barcode. It's really ingenious. Put an asterisk fore and aft, change the font and... voila, a scannable code eliminating the need to type in the part number when issuing items. Big productivity boost. I did a white out on the nomenclature font in the left column since that isn't a problem. I couldn't really change the data without it trying to do calculations on the non-existent historical data. So, those PN are real. As you can see, they barcode perfectly until they don't. Thanks for looking and for helping me brainstorm. I truly appreciate it.

 

[Alex Blakenburg]

Deleted. its a font not a number format need to rethink it

 

[Alex Blakenburg]

Ok same principle.
Hover over the bottom border of the Barcode column heading until you get a solid black arrow.
Click to select
Right Click > Format Cells
Set the desired Font
then OK

Can you see if the format you want sticks now ?