Hi guys,

since i am kind of new here, I want to apologize in advance if i dont post this in a correct way, but i have the following problem related to the conditional formatting, I have the following table :

Size N Bottom 5 Top 2 Target b5 Target top2
1753 7.97% 61.14% 12.1% 58.9%
462 17.25% 50.34% 14.3% 55.3%
201 3.95% 62.91% 10.0% 60.5%
553 7.17% 77.03% 7.2% 71.7%
2 0.00% 0.00% n/a n/a
167 10.19% 48.65% 12.8% 54.8%
368 5.19% 71.35% 6.7% 72.9%

Where i already sat the conditional formatting for bottom 5 and top2 , it compares it to the targets and paints in red, yellow, green depending on them, the problem is, that when Size is less than 30, i want to paint the corresponding size cell plus the adjacent bottom 5 and top2 cells in gray, also when size is => 30 i want the size cell to be white and the the 3 - colour rules to apply on the top2 and target b5 cells, and when size cell and corresponding bottom 5 top2 are blank to paint it also white. I hope i explained it well, cause to me it is also confusing how to apply the rules for all the cases. Any help will be appreciated. Thank you in advance!