Is it possible to conditionally color databar based on background color of another cell

Let me clarify. Color of the bar depends on the value of another cell which is a calculated average from a pivot table. If value is 0 to 4 color = Red, if value = 5 color = Yellow, if value 6 or 7 then color = Green.

Just below the single row that had the calculated average I added 3 more rows. Each had conditions for mirroring their data of the calculated average cell above. For the first cell if the value was <= 2 then display the calculated average if not show "". The same followed for the next two cells down and increasing the threshold. Then made a side-by-side bar graph using those three rows. Making sure to overlap the bars so whichever bar appeared was in the same location as where the other two would have been.
The last trick was to overlay that across the top of the original bar graph. I made the original bar 100% transparent so its M$ blue didn't show.

If I would prefer if Excel would allow me to set conditions in the FORMAT DATA SERIES under FILL OPTION. But I may have to wait until the next release.

Thanks

@ PizzaPete

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't properly marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.