3 Replies Latest reply on Sep 29, 2014 1:27 AM by ankit.narula

    Conditional coloring in a row pane

    Anjaiah K

      Hi,

       

      I have been trying this since friday and no luck as of now. I need to color back ground of a row by comparing total percentage calculated on a row pane. The conditions are

       

      1.If the Quadrant = 2 in the row is greater than the bottom row (the total), color the background behind the three numbers GREEN

      Example For "WT" = "B"; "band" = "B"; and "CS" = "NO", there were two data points: one with Quadrant = 2  is 63.64 % is higher than the column total (40.63% Effective), color this row( 18.18%,63.64%,18.18%) GREEN.

      2.If the Quadrant = 1 in the row is greater than the the bottom row (the total), color the background behind all three numbers RED

      3. If both of the above are true, color the individual numbers RED or GREEN as shown in the example in the upper right of the attached powerpoint quarter 2 cell value should be green and quarter1 cell value should be red and quarter 3 should be white.Otherwise, color the background behind all three numbers WHITE

       

       

      Can some one help on this? Thanks in advance.