Conditional background formatting

parry2k thank you for your response!

Not sure if I was clear, I want the background colour to be based on the rows. Let me try to reprhase: 

I want the MIN and MAX to of the gradient to use the MIN and MAX of each row. Not the whole table.

Right now, the gradient would take MIN: 1 and MAX: 8 to colour all the cells in the table. Where I would like that row 2 (Customer X) uses MIN 4 and MAX 8 to set the gradient colour. And for row 3 (Customer Y) to use MIN 1 and MAX 4

This is an example of how I use it right now:

As you can see, H2 and L2 are dark red, because there is a significant drop (4 points).
I2, H4, and L4 are dark blue, because there is asignificant gain. For Customer X it is a gain of 4, and for Customer Z it is 2 points.