AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells.
Passing column, start row and end row as well as Sheet name and Workbooks as usual.
You can also decide the color.
Maybe next version, we can add more options to databar, like transparency.
If you need to not show value and show only bar, change .ShowValue = True to .ShowValue = False.


Public

Tested

My Own Work

ColumnAddress, StartRow, EndRow, RankColor, Optional Shee = "Active", Optional WB = "This"

Views 2 Downloads 0