One toggle button for all pages

Hi AishwariyaV ,

Click on the link below to get to the display.  You have to click on both buttons in a column to activate the formatting on both pages and keep both pages in sync.

Using Slicers and Bookmarks

Here is what I was able to come up with. 

1. The settings for the slicer can be saved in a bookmark. The slicer can be copied and pasted on all your pages. I used this with a table that listed the two states, and was able to reflect that on each page to verify in print what we had selected. You can make the slicer invisible on the subsequent pages.

2. After trying many deadends bookmarks can't be spread over two pages. Also  you cannot make an shape invisible and still active or stack them so that you can push multiple buttons at once. 

3. This is what I have come up with so far. A different button for each page that leads to different bookmarks. It is kind of cool, but I know not what you are looking for.  The only benefit is that you could click on on ten buttons in a column pretty quickly. Currently I turned off the page location on the bookmark so clicking on it sets the value format, but does not take you to the page.

You could redo this as a menu of pages, and make your pages not visible until you click on the menu button. Then have two menus, one with formatting by millions and the other by no format. Then it is less obvious, because you are offering them a menu to get to the page in the formatted style they desire. Put a back button on each page, and they go back to the first page.

A lot of work. Let me know how it goes.

You can also check out something like this which is all bookmarks, and just copy each page to make a second page with the correcct formatting. Then as I said it would look like they were getting a cool menu. My dashboard with bookmarks

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel