szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
Is it possible to automatically apply data bars to pivot table like this?
As you can see there are individual data bars for every subcategory (dates) , and they are not related to each other on category level (item)
To make it more clear on what I mean, here is how it would look like if I used standard automatic formatting for date values:
So I wonder if there is any workaround or VBA code to apply conditional formatting individually for every subcategory ? (as in 1st pic)
As you can see there are individual data bars for every subcategory (dates) , and they are not related to each other on category level (item)
To make it more clear on what I mean, here is how it would look like if I used standard automatic formatting for date values:
So I wonder if there is any workaround or VBA code to apply conditional formatting individually for every subcategory ? (as in 1st pic)
