5 Replies Latest reply: Jan 28, 2014 9:33 AM by Sven Arnold RSS

    Problem with formula for setting color in Textbox

      Hello everybody,

       

      I have a problem with a formula. The formula looks like:

       

       

      IF(index(concat(Datum_verg&Severity,','),'4NM')>0,Yellow(),

      IF(index(concat(Datum_verg&Severity,','),'4I')>0,LightBlue(),

      IF(index(concat(Datum_verg&Severity,','),'4A')>0,LightRed(),

      IF(DAY(MakeDate(Year(Today()),Month(Today()),4))<DAY(Today()),LightGreen(),White()))))

       

      For examplI if I have data in my table for the 24.01.2014 so Datum_verg will create with 24. The textbox of the 24 will mark with the color for Severity. But the Textbox for the 4 will also mark like the 24.

       

      See for more information the attachment.

       

      What can I do can anyone help me.

       

      Thanks

      grettings sven