Conditional Background colours

[hopkinsc]

Hi all,

I have a table in QS, i am trying to set the colours like the below  image.. 

I need to set the lowest value per row green and the highest value per row red but i can't seem to do it in Qlik Sense. 

The expression is

SUM([Duration Handover IPT Excess])/86400

Can anyone help please?

[hopkinsc]

I have tried the following which i thought would work but it doesn't colour the lowest value as below. 

=if(min(aggr(SUM([Value]),[Dim1])),green())

I have highlighted the correct value that should be coloured. 

Can anyone see anything wrong with the expression?