Set Conditional Formatting DataBar Border Color

[geoced]

Hello,

I'm using Add-ConditionalFormatting -Address $range -DataBarColor 'Red' -PassThru to set a data bar color on some cells, but compared to the manual way of doing using Excel's GUI, the difference is that the data bar color is left unchanged by ImportExcel, while Excel sets it to a slightly darker color than the data bar gradient color.

Excel GUI

ImportExcel

Is there a way to set the data bar border color or is this not supported by EPPlus ?

Thanks in advance !

[dfinke]

Thanks. That is an EPPlus question. The version I'm using may not support this. Worth searching.

[geoced]

Hello Doug,
Just to let you know that version 7.0 of EPPlus supports a whole range of additionnal settings for databars, including databar border color, as described here.
Which version of EPPlus is bundled with the latest version of the ImportExcel PowerShell module ?
Thanks !

[dfinke]

Yes. The PS module uses version 4.x. The new versions had many breaking changes and in most cases requires a paid license.