How to use conditional formatting for this particular column

[katdbc]

I having a column called 2011 prjections vs actuals.It has basically values in percentages.If the values  is negative then it should in green  color .if its 1-5 % its yellow and all the percentage greater than 5 % should be in red.Howdo i do this using the conditional variables. which one should I use? and how do i do it?

It wil be great  if somebody can help me? still suffering wit a deliverable.

[AussiePete2011]

In Report Studio, from the menu select Tools, then "Manage Conditional Styles"

Also have a read of
http://www.ibm.com/developerworks/data/library/cognos/reporting/dynamic_report_design/page553.html?ca=drs-
https://www.packtpub.com/sites/default/files/0349-chapter-2-advanced-reportauthoring.pdf

Hope this helps
Cheers
Peter B

[Ramesh Sanka]

expression
case
when 2011 prvsactual<=0.00 then 'green'
when 2011 prvsactual between 0.01 and 0.05 then 'Yellow'
when 2011 prvsactual>0.05 then 'Red'
end
Use the above expression and apply general conditional formating.

[katdbc]

Thank you all,IT really helped me ;D