Colour Pivot Filters When Active

nflami

New Member
Joined
Apr 16, 2014
Messages
25
My goal is to highlight the cell when I have a filter active in the pivot table row & column labels.

I have found the linked document below which shows me how to accomplish what I'm looking for in regards auto filters. What I would like to do is perform this same action in a way that functions within a pivot tables filters (the row & column labels).

To find the document search for "FL0014 - Colour Filter Headings" Under the filters section
https://www.contextures.com/excelfiles.html#Filter

Thanks in advance!
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,108,708
Messages
5,524,431
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top