You can use expression attributes to set the background color. On expression tab, open the attributes of your expression by clicking on the small + sign next to the expression label in the upper left box.
For background color, use a definition like
=if(rank(Chance) <= count(total Project)*0.1,LightGreen(),
if(rank(-Chance) <= count(total Project)*0.15,lightred()
See also attached.
comm64869.qvw 147.2 K