gurusleven
New Member
- Joined
- Feb 9, 2012
- Messages
- 1
I have a table setup that drives my pivot table. My pivot table then drives my chart. I have identical conditional formatting applied to both the table and the pivot table, but need VBA to assign the same conditional formatting to the chart.
The chart will change month by month so the values can change per day and then per month. I have a slicer set up so the person printing can just pick the month to view and then hit print.
Colors needed are: >59 red, between 60 and 90 yellow, >90 green.
I am new to VBA and have no idea where to start. Please Help!
The chart will change month by month so the values can change per day and then per month. I have a slicer set up so the person printing can just pick the month to view and then hit print.
Colors needed are: >59 red, between 60 and 90 yellow, >90 green.
I am new to VBA and have no idea where to start. Please Help!
