In this article, we have created multi-color data bar in Excel cells using REPT function. We have used the conditional formatting to change the color based on certain criteria.
Multi-color data bar in Excel
![Multi-color Data bar](https://www.pk-anexcelexpert.com/wp-content/uploads/2022/07/Multicolor-data-bar-with-REPT-function.jpg)
Visit our YouTube channel to learn step-by-step video tutorials
Watch the step-by-step video tutorial:
See our related templates:
- Multicolor Filling Bars in Excel Cells Without using Chart
- Chapter – 3: Data Bars
- Progress Bar Chart in Excel