pls check brother
mycolor=IIf(m1<0 AND m1>s1, colorWhite,IIf(m1>0 AND m1>s1,colorGreen,IIf(m1>0 AND m1<s1,colorOrange,colorDarkRed)));
histcolor = IIf((m1-s1)-Ref((m1-s1),-1)> 0,colorLime,colorRed );
mycolor=IIf(m1<0 AND m1>s1, colorWhite,IIf(m1>0 AND m1>s1,colorGreen,IIf(m1>0 AND m1<s1,colorOrange,colorDarkRed)));
histcolor = IIf((m1-s1)-Ref((m1-s1),-1)> 0,colorLime,colorRed );
mycolor=IIf(m1<0 AND m1>s1, colorDarkGreen,IIf(m1>0 AND m1>s1,colorGreen,IIf(m1>0 AND m1<s1,colorDarkRed,colorRed)));
histcolor = IIf((m1-s1)-Ref((m1-s1),-1)> 0,colorLime,colorRed )
here green & red r strong. and dark green & red r weak.
----------------------------------------------------------------------------------------------------------
mycolor=IIf(m1<0 AND m1>s1, colorGreen,IIf(m1>0 AND m1>s1,colorDarkGreen,IIf(m1>0 AND m1<s1,colorRed,colorDarkRed)));
histcolor = IIf((m1-s1)-Ref((m1-s1),-1)> 0,colorLime,colorRed )
here green & red r weak. and dark green & red r strong.