conditional formatting

[barrysaab]

My requirement is something like this:

%py sales

Week1- 15%

Week2-25%

Week3 35%

Week438



Total January 38%



We have stored values like this: month=2

                                                                    Quarter=3

                                                                       Year=4



And we need to format on month,quarter and year.I wrote a expression like this :



if([Report Query].=2)and [Report Query].[% vs. LY] <%value then ('green')

else if

([Report Query].=3) and [Report Query].[% vs. LY] between  %value and %value then ('yellow')

else if

([Report Query].=4) and [Report Query].[% vs. LY]>1 then ('Red')



It is not coming up right.please help.Thanks