background formatting in crystal reports

This question is answered

I have a Crystal Report in Vs 2010. I'm Trying to format the background of a Column, Based on data values. Using this code only the first condition Works because I tried to switch the if conditions and again only the first condition works.

IF {TBM_Report_qry.DiF}<={TBM_Report_qry.tbm} then RGB(234,234,234)else( IF {TBM_Report_qry.inproduction_DiF}<={TBM_Report_qry.Reqired} then RGB(234,234,234) else ( IF {TBM_Report_qry.DiF_Close}<={TBM_Report_qry.clse_Diff} then RGB(234,234,234) ))