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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Matching pivot table format for adjacent cells when filtering
Excel Facts
Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Similar threads
- Replies
- 0
- Views
- 521
- Question
- Replies
- 0
- Views
- 39
- Replies
- 4
- Views
- 493
- Replies
- 0
- Views
- 269
- Replies
- 1
- Views
- 366
