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
