B1:=REF(C,1);B2:=REF(C,2);
SS:=IF(C>REF(C,1) AND REF(C,1)>=REF(C,2),1,IF(C<REF(C,1) AND REF(C,1)<=REF(C,2),-1,IF(C>REF(C,2) AND REF(C,2)>REF(C,1),2,IF(C<REF(C,2) AND REF(C,2)<REF(C,1),-2,0))));
SM:=IF(REF(SS,1)<>0,REF(SS,1),IF(REF(SS,2)<>0,REF(SS,2),IF(REF(SS,3)<>0,REF(SS,3),IF(REF(SS,5)<>0,REF(SS,5),IF(REF(SS,6)<>0,REF(SS,6),IF(REF(SS,7)<>0,REF(SS,7),0))))));
绿柱:=(ss<=-1 AND sm<=-1) OR (ss=0 AND SM<=-1);
红柱:=(ss>=1 AND sm>=1) OR (SS=0 AND SM>=1);
绿变红柱:=ss>=1 AND sm<0;
红变绿柱:=ss<=-1 AND sm>0;
(REF(绿柱,2) OR REF(红变绿柱,2)) AND REF(绿柱,1) AND 绿变红柱;