Conditional Formatting in a Bubble Chart

[ms.mount]

I have the following table:
chart1.png

If the bubble size is 0-5, I need the bubble color to be green
If the bubble size is 6-15, I need the bubble color to be yellow
If the bubble size is 16-25, I need the bubble color to be red.

So, right now my chart looks like this: chart.png

As you can see the top bubble is the right color, but based on the bottom bubble value, it should be green.

How do I make this change colors dynamically based on the bubble size value?

[MrShorty]

I don't know how others would do it. I have always felt that, when I want a group of points in a chart to look different, it was easiest to add each group as a separate series. Then each series can be easily formatted the way you want it. Doing it this way makes the problem more of a spreadsheet problem where you have to figure out how to conditionally fill a range with the desired values. This is often easily accomplished using the =IF() function. Use the =IF() function to determine which points belong in which data series, pull the data into the desired range, then plot those three data series. If you don't want to actually see these "helper" ranges, they can be hidden or moved to an out of the way part of the spreadsheet.

Example using random numbers here (I have assumed y=x is always true as your sample data indicate).