Hi Guys
I am trying to apply conditional formatting to a pivot table with grouped data.
Rules:
> I want to highlight the smallest points in each group which have a volume below the average. For example, Mike in Group A has the lowest average point and his average volume is below Group A's average volume. Therefore I would like Mike to be highlighted.
>I want a way of displaying the difference between the highest and lowest points in each respective group. So for example in Group A i want to see the difference between Mike and Tom's points in % since they are the highest and lowest. In addition i want a flexible way of adjusting the acceptable % to display. For example i may only want to see point differences with a 30% gap/difference.
Many thanks
Bookmarks