Export (0) Print
Expand All

FormatConditions.AddDatabar Method

Office 2007
Returns a Databar object representing a data bar conditional formatting rule for the specified range.

Version Information
 Version Added:  Excel 2007

Syntax

expression.AddDatabar

expression   A variable that represents a FormatConditions object.

Return Value
Databar object

Remarks

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.




Community Additions

ADD
Show:
© 2015 Microsoft