0 Replies Latest reply: Jul 13, 2015 3:50 AM by Armin Rauscher RSS

    table background coloring based on the value

    Armin Rauscher

      Hello,

       

      I have again a question or problem and hope somebody can help.

      I have created a straight table which is somehow dynamically, this means the user can choose dimensions and expressions by himself and the straight table will be updated. i want now to color the background according the value of the table, but i dont want to use the formula behind, because this formula is somehow complicate because of the dynamic calculation. Is there a possibility to color it automatically based on the calue of each cell?

       

      i would like to define ranges like

       

      If(cellvalue<0.7,RGB(165,0,38),If(cellvalue<0.9,RGB(217,239,139),If(cellvalue<1.0,RGB(102,189,99),If(cellvalue<1.1,RGB(244,109,67),If(cellvalue<1.5,RGB(253,174,97),If(cellvalue>=1.5,RGB(0,104,55)))))))

       

      thanks, armin