Conditional Formatting help for fill base on %

[jp16]

Hi, i am trying to show how many % each brand is. I have 3 Brand. Their total make up 100%. I have a box where i have 1% 2% all the way to 100%. Each brand has a Colour. Hence, if Brand A is 50% (red), Brand B is 30% (Yellow). Brand C is 20% (Blue). The box should have 50% of cell fill with Red. Then 51% to 80% fill with Yellow while the rest is Blue. I have no problem for the first 50% conditional formatting. HOwever, the formula i key in for the next 20% somehow doesnt work. I duno y. Can any one help?

[benishiryo]

hi there. you probably selected the wrong cells. delete your current conditional formatting for the red, and try this.
select the range you want to apply to (say from B2:K11)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=AND(B2>$P$1,B2<=$P$2)

you can also use an easier way. remove ALL conditional formatting. elect the range you want to apply to (say from B2:K11)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=B2<=$P$3
format blue

and later in this particular order.
=B2<=$P$2
=B2<=$P$1

this works because the Conditional Formatting will input the latest Conditional Formatting you did first. once it checks that cell is <=59%. it then checks for <=88% since yellow will be checked first. it will not overwrite the yellow

[jp16]

Is it possible to Outline each brand?