ExcelConditionalFormatValueObjectType Enumeration

In This Topic

This simple type expresses the type of the conditional formatting value object (cfvo). In general the cfvo specifies one value used in the gradated scale (max, min, midpoint, etc).

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ExcelConditionalFormatValueObjectType 
   Inherits System.Enum

'Usage
 
Dim instance As ExcelConditionalFormatValueObjectType

public enum ExcelConditionalFormatValueObjectType : System.Enum

Members

Member	Description
AutoMax	The larger of zero or the maximum value from the range of cells that the conditional formatting rule applies to.
AutoMin	The smaller of zero or the minimum value from the range of cells that the conditional formatting rule applies to.
Formula	The minimum/ midpoint / maximum value for the gradient is determined by a formula.
Max	Indicates that the maximum value in the range shall be used as the maximum value for the gradient.
Min	Indicates that the minimum value in the range shall be used as the minimum value for the gradient.
Num	Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.
Percent	Value indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient.
Percentile	Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient
Stddev	Indicates the item represents the "standard deviation" aggregate function.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Excel.ExcelConditionalFormatValueObjectType

Reference

GrapeCity.Excel Namespace