Adding Color Scheme to Data Bars in Excel Using Conditional Formatting

1. Select the cells that contain the data bars you want to format.
2. Click on the "Conditional Formatting" button in the "Home" tab of the ribbon.
3. Select "New Rule" from the drop-down menu.
4. In the "New Formatting Rule" dialog box, select "Format only cells that contain" from the "Select a Rule Type" section.
5. In the "Edit the Rule Description" section, choose "Cell Value" from the first drop-down menu, "between" from the second drop-down menu, and enter "1" and "3" in the two boxes.
6. Click on the "Format" button and select the "Fill" tab.
7. Choose the red color you want to use for the data bars and click "OK".
8. Click "OK" again to close the "New Formatting Rule" dialog box.
9. Repeat steps 4-8 for the other two ranges (4-6 and 7-10), using yellow and green colors respectively.

Once you've set up these rules, the data bars in your selected cells will change color based on the value in the cell. If the value is between 1 and 3, the data bar will be red. If it's between 4 and 6, it will be yellow, and if it's between 7 and 10, it will be green.