Hope someone can help me with this... I'm working on a pivot table and have formatted month figures to show green when they are below month target and red when they are above. For the Total column (partial sum), I want to apply the same formatting against a year target, not the month target.
If anyone can advise if there is a way to do this, I would be very grateful.
