Hi,

I am working on dashboard type tracking list. I am using the conditional
formatting Data Bars to show progress based on a 1-10 number scale. I am
using just a simple grey color for the actual data bar.

A friend asked if I could add a color scheme to the data bar such that it
changes depending upon the actual number in the cell:

1-3 = Data bar is Red
4-6 = Data bar is Yellow
7-10 = Data bar is Green

any suggestions?

thanks,