Pivot Table Formatting Not Transferring

Justinian

Well-known Member
Joined
Aug 9, 2009
Messages
1,476
Office Version
  1. 365
Platform
  1. Windows
I have a basic data set of open work orders from A2:L2000. In column L, I have an "=" sign formatted as Webdings so the result is a colored circle. The problem is when I create a pivot table from this data set, the colored circle reverts back to an "=" sign and when I format the pivot table column as Webdings, the colored circle returns but as soon as I collapse or expand that row, the "=" comes back.

How do I get the formatting to hold in the pivot table?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
568
Office Version
  1. 365
Platform
  1. Windows
Are you formatting the Pivot table field and not just the worksheet cells ?
I think because its not a numeric field you are not getting formatting options when you go to field settings.

Hover over the fields title until you get a black arrow (left picture below) then left click to select it should look like the left below,
then hover over one of the selected cells and right click, you should get a menu that looks something like the right picture below.
Then either in the left top font box or under Format cells, select Webdings

1616570486969.png
 
Solution

Justinian

Well-known Member
Joined
Aug 9, 2009
Messages
1,476
Office Version
  1. 365
Platform
  1. Windows
I did that and it was not working but now it is, so I must have done something wrong.

Thank you!
 

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
568
Office Version
  1. 365
Platform
  1. Windows
Glad it works now. Do you mind clicking on the Mark as Solution, so others helping out know the issue has been resolved ?
Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,529
Messages
5,636,853
Members
416,945
Latest member
Himu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top