Green
If (Value 2 > 0 AND  Value 2 > Purple Magic AND Value 2 < Close ) OR  (Value 3 > 0 AND  Value 3 > Purple Magic AND Value 2 < Close ) 
OR (Value 3 > 0 AND  Value 3 > Purple Magic AND Value 2 < Close ) OR (Value 4 > 0 AND  Value 4 > Purple Magic AND Value 2 < Close ) 
OR (Value 5 > 0 AND  Value 5 > Purple Magic AND Value 2 < Close ) OR (Value 6 > 0 AND  Value 6 > Purple Magic AND Value 2 < Close ) 

Red 
If (Value 2 > 0 AND  Value 2 < Purple Magic AND Value 2 > Close ) OR  (Value 3 > 0 AND  Value 3 < Purple Magic AND Value 2 > Close ) 
OR (Value 3 > 0 AND  Value 3 < Purple Magic AND Value 2 > Close ) OR (Value 4 > 0 AND  Value 4 < Purple Magic AND Value 2 > Close ) 
OR (Value 5 > 0 AND  Value 5 < Purple Magic AND Value 2 > Close ) OR (Value 6 > 0 AND  Value 6 < Purple Magic AND Value 2 > Close )