Conditional Format the MAX Value in a ROW in a Expanding Pivot Table

[spudd]

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

 

[GraH]

Like this?