I have Data Bars with 5 values represented. I need the bar to be formatted by color based on the value. e.g. if the value is either 3.5 or 4 the data bar should display green, if the value is 3 the bar should disploay blue, etc.

I am using Excel 2010.

WAK