Excel tutorial on conditional formatting. Styling conditional formatting data bars color you can pick the fill of your choice by fill we mean gradient fill like the one in the image above or the solid fill. Select the range of cells. Formulas that apply conditional formatting must evaluate to true or false. To add an icon sets follow these steps.
After picking the color of your choice and selecting the mode of fill you get your data in data bars.