Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any way to do this, example of max's highlighted below
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
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!