Thanks that certainly speeds up my process no end, much appreciated

Is there a formula that I could perhaps use in B20 to change the values in S1, 2, 3 & 4 when I enter the ideal split % in B20?

Using my rules of 13% either side of the ideal split for Amber and 5% either side for Green?

Thanks again,
Ewen