Conditional Formatting Question RS 2005

Hi,



Does anyone know how to implement conditional formatting with three criteria (e.g. If a value is <83 then BGcolour Green, between 83 and 90 the BGcolour is Yellow, greater than 90 the BGcolour is green).



I have tried approaching it in two ways. One was with a case statement as follows:



CASE

WHEN TargetPer < 83 THEN 'Red'

WHEN TargetPer >= 83 AND TargetPer < 90 THEN 'Yellow'

WHEN TargetPer >= 90 THEN 'Green'

END AS BGColor



TargetPer being the value i wish to examine. I returned this in the query dataset i am using to populate the report. I then used the following expression to set the backgroundcolor property:



=Fields!BGColor.Value



Unfortunately I get no yellow fields for the appropriate values (even though the BGcolor value says yellow!!!)



The other approach i have used is the following expression to set the background colour



=IIf(Fields!TargetPer.Value>90,"Green",IIf(Fields!BGColor.Value>=83 and Fields!BGColor.Value <=90, "Yellow","Red"))



For this i still have no yellows just reds and greens!



I am using a matrix report that has subgroups on the columns for table!



Any ideas anyone????



Thanks



Marek