
Re: change color text in table
Susann Ullrich Dec 17, 2012 10:28 AM (in response to edwin1269)Hello Ed,
try using this formula:
if( sum(A) <= ((sum(A)+sum(B)+sum(C))/3) * 0.1, rgb(255,0,255),
if( sum(A) <= ((sum(A)+sum(B)+sum(C))/3) * 0.3, rgb(255,255,0),
if( sum(A) <= ((sum(A)+sum(B)+sum(C))/3) * 0.7, rgb(0,0,255),
if( sum(A) <= ((sum(A)+sum(B)+sum(C))/3) * 0.9, rgb(255,0,0),
if(sum(A) > ((sum(A)+sum(B)+sum(C))/3) * 0.9, rgb(0,255,0) ) ) ) ) )You just have to change the rgbvalues to the ones you need.

Re: change color text in table
Miguel Angel Baeyens de Arce Dec 17, 2012 10:30 AM (in response to edwin1269)Hi,
Let's say you have the Average in column number 5 (fifth expression) counting from the left. Then, the condition to get colors I'd use is:
If(Column(5) < .1, Color1, If(Column(5) < .3, Color2, If(Column(5) < .70, Color3, If(Column(5) < .90, Color4, Color5))))
Note that If() conditions in charts may degrade performance with large data sets.
Hope that helps.
Miguel

Re: change color text in table
Gysbert Wassenaar Dec 17, 2012 10:30 AM (in response to edwin1269)Something like:
if(sum(A)<0.1*(sum(A)+sum(B)+sum(C))/3,green(),
if(sum(A)<0.3*(sum(A)+sum(B)+sum(C))/3,red(),
if(sum(A)<0.7*(sum(A)+sum(B)+sum(C))/3,blue(),
if(sum(A)<0.9*(sum(A)+sum(B)+sum(C))/3,yellow(),
magenta()))))

Re: change color text in table
edwin1269 Dec 20, 2012 6:45 AM (in response to Gysbert Wassenaar )Thanx again, expression worked out fine for me.
Bedankt en hopenlijk tot een volgende keer
