Need help to color Trendline or Expression line.

[#1]

Hi,

     In bar chart i have added the Referance line Target & Threshold.

    The Target indicate green line & Threshold indicate Red line.

     Also the Blue line is Linear Trendline or expression. so i want to make

    that Trendline or expresion line colored on the basis of following conditions.

     IF Blue line appears in between Target & threshold then Yellow ,

     IF Blue line goes above Threshold(Red Line) then Pink.

     IF Blue line goes below  Target (Green Line) then Green.

              Consider any 1 blue line i.e. Trendline or Expression line to color.

               Pls see the attached qvw file for ref.

                i am a beginer ....pls suggest solution.

Thanks