bhieb
asked on
Excel 2007 Pivot Table Icon Set
Ok So I have a list of vehicles and the number of loads they ran in a pivot table.
Site | # Loads
Site A | 10
Veh1 | 4
Veh2 | 3
Veh3 | 3
Site B | 20
Veh11 | 14
Veh12 | 3
Veh13 | 3
The problem is I want an icon set under each site (indicated by Bold). If I expand all and manually select and apply the conditional format it works fine, but is there anyway to tell it to do so automatically. Because any data refresh messes it up.
Site | # Loads
Site A | 10
Veh1 | 4
Veh2 | 3
Veh3 | 3
Site B | 20
Veh11 | 14
Veh12 | 3
Veh13 | 3
The problem is I want an icon set under each site (indicated by Bold). If I expand all and manually select and apply the conditional format it works fine, but is there anyway to tell it to do so automatically. Because any data refresh messes it up.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's what I was afraid of Zack. I'll hold this open another 24 hours just to be sure no one else has options, if not I'll toss you the points.
ASKER