Hi
I have a table with 5 columns and I want to put this expression for the background color;
If xi > avg(x) + 3*stdev(x) OR xi < avg(x) - 3*stdev(x) THEN highlight
This is what I want to achieve, if column one is XI; then column 2,3,4 is X.
Then do this: Starting from column one, for to highlight column one, I firstly have to get the avg of column 2,3,4 and 5, add it with (3 * standard deviation of column 2,3,4 and 5 values) , then see if the value I get is below column one(which is XI on this instance),
And the same applies for other columns, if I want to see if I can highlight column two, I need to get the avg of column 1,3,4 and 5, then add that with (3 * standard deviation of column 2,3,4 and 5 values) then see if the value I get is below column two(which is XI on this instance).
Please help me on how can I get around this issue, or maybe if that's a better way.