Hello,
Does anybody know how to automatically highlight the highest value in each row label of a pivot table?
In this example, I would like to highlight the highest selling fruit in each state. I couldn't find this option in conditional formatting.
Thanks.
[TABLE="width: 144"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sum of Amount[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Arkansas[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]611.00 [/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]441.00 [/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]1,607.00 [/TD]
[/TR]
[TR]
[TD]Strawberries[/TD]
[TD]800.00 [/TD]
[/TR]
[TR]
[TD]Arkansas Total[/TD]
[TD]3,459.00 [/TD]
[/TR]
[TR]
[TD]Delaware[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]1,506.00 [/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]450.00 [/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]950.00 [/TD]
[/TR]
[TR]
[TD]Peaches[/TD]
[TD]200.00 [/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]806.00 [/TD]
[/TR]
[TR]
[TD]Delaware Total[/TD]
[TD]3,912.00 [/TD]
[/TR]
[TR]
[TD]Iowa[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]200.00 [/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]700.00 [/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]645.00 [/TD]
[/TR]
[TR]
[TD]Peaches[/TD]
[TD]800.00 [/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]230.00 [/TD]
[/TR]
[TR]
[TD]Iowa Total[/TD]
[TD]2,575.00 [/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD]9,946.00 [/TD]
[/TR]
</tbody>[/TABLE]
Does anybody know how to automatically highlight the highest value in each row label of a pivot table?
In this example, I would like to highlight the highest selling fruit in each state. I couldn't find this option in conditional formatting.
Thanks.
[TABLE="width: 144"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sum of Amount[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Arkansas[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]611.00 [/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]441.00 [/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]1,607.00 [/TD]
[/TR]
[TR]
[TD]Strawberries[/TD]
[TD]800.00 [/TD]
[/TR]
[TR]
[TD]Arkansas Total[/TD]
[TD]3,459.00 [/TD]
[/TR]
[TR]
[TD]Delaware[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]1,506.00 [/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]450.00 [/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]950.00 [/TD]
[/TR]
[TR]
[TD]Peaches[/TD]
[TD]200.00 [/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]806.00 [/TD]
[/TR]
[TR]
[TD]Delaware Total[/TD]
[TD]3,912.00 [/TD]
[/TR]
[TR]
[TD]Iowa[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]200.00 [/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]700.00 [/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]645.00 [/TD]
[/TR]
[TR]
[TD]Peaches[/TD]
[TD]800.00 [/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]230.00 [/TD]
[/TR]
[TR]
[TD]Iowa Total[/TD]
[TD]2,575.00 [/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD]9,946.00 [/TD]
[/TR]
</tbody>[/TABLE]