title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
FormatConditions.AddDatabar method (Excel) |
vbaxl10.chm510080 |
|
|
4e22e749-860b-4224-b983-ba6dbbc7096a |
04/26/2019 |
medium |
Returns a Databar object representing a data bar conditional formatting rule for the specified range.
expression.AddDatabar
expression A variable that represents a FormatConditions object.
Databar object
Data bars help you see the value of a cell relative to other cells. The length of the data bar represents the value in the cell. A longer bar represents a higher value and a shorter bar represents a lower value.
Data bars are useful in spotting higher and lower numbers, especially with large amounts of data, such as top and bottom selling toys in a holiday sales report.
[!includeSupport and feedback]