Color fields in pivot based on group totals

KongGulerod

New Member
Joined
Feb 23, 2017
Messages
17
Office Version
  1. 2013
Platform
  1. Windows
I have a dataset that I view in a pivot table. To make it easier to view I want to color the table based on the total of the group. If the group total is blank I want it to have a color. But I also want the rest of the fields in the group to be colored. Is it even possible? The data is dynamic and is changed on a weekly basis. The original data is not about what people drink... ;-)

Data example:

DepartmentUserDrink
Dep1Usr1Beer
Dep2Usr2Beer
Dep3Usr3Wine
Dep1Usr4Water
Dep2Usr5Beer
Dep3Usr6Beer
Dep1Usr7Water
Dep2Usr8Water
Dep3Usr9Beer
Dep1Usr10Beer
Dep2Usr11Wine
Dep3Usr12Wine
Dep1Usr13Beer
Dep2Usr14Beer
Dep3Usr15Wine
Dep1Usr16Water
Dep2Usr17Beer
Dep3Usr18Beer

The Pivot looks like:
1707286766832.png


My conditional rules looks like:
1707286822430.png


What I really want my Pivot to look like (colored by hand):
1707286954539.png


I can not seam to find a solution.
I fear it's not possible.
 

Attachments

  • 1707286923655.png
    1707286923655.png
    13.6 KB · Views: 15

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,223,243
Messages
6,170,971
Members
452,371
Latest member
Frana

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top