Any ideas how to Format the Max value for each row in a Pivot Table as the Table is expanded and Shrunk.
There are about 70 Rows and would like each row to have a cell Formatted to say where it is the highest value, to compound the Pivot also expands and contracts as the user changes any datasets.
Cheers in anticipation.
Andy
There are about 70 Rows and would like each row to have a cell Formatted to say where it is the highest value, to compound the Pivot also expands and contracts as the user changes any datasets.
Cheers in anticipation.
Andy