ExcelBanter - How do I turn off gradient fill for data bars in condit. formattin

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I turn off gradient fill for data bars in condit. formattin (https://www.excelbanter.com/excel-discussion-misc-queries/200316-how-do-i-turn-off-gradient-fill-data-bars-condit-formattin.html)

Matt

How do I turn off gradient fill for data bars in condit. formattin

I discovered the data bar feature in conditional formatting in Excel.
However the bars all seem to be gradient fills. How do I create a solid fill?

All times are GMT +1. The time now is 10:50 PM.