21 Replies Latest reply: Apr 20, 2017 4:59 AM by Deepak Sharma RSS

    Colour code by expreesion

    Charlie Leo

      Hi all ,

       

      does the following code is correct? not working actually

       

      if(Status='Sanctioned But Not Disbursed',$(Blue),

      if((Today-Date1)>=0 and (Today-Date1)<=1,$(Pink),

      if((Today-Date1)>=2 and (Today-Date1)<=3,$(Yellow),

      if((Today-Date1)>=4 and (Today-Date1)<=5,$(Green),

      if((Today-Date1)>=6 and (Today-Date1)<=14,$(Blue),

      if((Today-Date1)>=15 and (Today-Date1)<=30,$(Blue),

      if((Today-Date1)>=31,$(Beige))))))))

       

       

      Any Advice

       

      Regards

      Charlie