I currently have a pivot table of counts, and due to some additional calculations have added several adjacent columns with consistent formatting. My issue comes when I try to use the slicers, and the formatting of the adjacent (non-pivot) cells no longer matches the pivot table cells. Is there a formula or some way to match the adjacent pivot table cell and update the formatting when a slicer is used?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
