Highlight the Background with Yellow based on expression

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply