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.
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin LoginColumnAddress, StartRow, EndRow, RankColor, Optional Shee = "Active", Optional WB = "This"
Views 253
Downloads 91
CodeID
DB ID
ANmarAmdeen
701
Revisions
v1.0
Monday
August
22
2022