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

# Conditional coloring in a row pane

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.

• ###### 1. Re: Conditional coloring in a row pane

Pic attached. I have just highlighted but cell should colored fully. I do not have any values two criteria at the movement here but in actual the third condition happens. we should have both colors in for both CS=Yes and CS=no

• ###### 2. Re: Conditional coloring in a row pane

Hi Anjaiah,

I took a look at this and got most of the way there in terms of coloring, then I had to put it down for a few days. Are you still looking for help doing this?

Jonathan

• ###### 3. Re: Conditional coloring in a row pane

Hi ,

I was looking for some help and happened to see your post.

I am actually looking to colour only one column and when I am trying to do shading through format of that ,its colouring every column.

Can you help?

Thanks