9 Replies Latest reply: Aug 18, 2017 4:00 AM by sriram s RSS

    back ground color

    sriram s

      Hello all,

       

      I have requirement based on the values of if condition the back ground color needs to be applied. The given expression is

       

      =IF(IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

      IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1))))) >=0.9,'G',IF(

      IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

      IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1)))))<0.75,'R','A'))

       

      So For G -Green

      A -Yellow

      R - Red

       

      The back ground needs to be applied for the value of R,A and G.

       

      Can anyone please suggest me how to provide the back ground color for the above condition.