Hihglight min and max in all rows of Pivot

[dmac1971]

Any way to do this, example of max's highlighted below

[antoniotiman]

If You want Red as Min

If(RangeMax(First(Sum(Value),1,NoOfColumns()))=Sum(Value),Green(100),
If(RangeMin(First(Sum(Value),1,NoOfColumns()-1))=Sum(Value),Red(100)))

Regards,

Antonio

[dmac1971]

Brilliant guys thanks for this, will get a look at it next week, travelling with work for a few days so might not be until later in week.  A useful chart I think though for looking at say order intake and sales across categories!