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.
<tbody>
</tbody>
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.
| Sum of Amount | |
| Row Labels | Total |
| Arkansas | |
| Apples | 611.00 |
| Bananas | 441.00 |
| Oranges | 1,607.00 |
| Strawberries | 800.00 |
| Arkansas Total | 3,459.00 |
| Delaware | |
| Apples | 1,506.00 |
| Bananas | 450.00 |
| Oranges | 950.00 |
| Peaches | 200.00 |
| Pears | 806.00 |
| Delaware Total | 3,912.00 |
| Iowa | |
| Apples | 200.00 |
| Bananas | 700.00 |
| Oranges | 645.00 |
| Peaches | 800.00 |
| Pears | 230.00 |
| Iowa Total | 2,575.00 |
| Grand Total | 9,946.00 |
<tbody>
</tbody>
