ig.excel.DateTimeConditionalFormat
Remarks
This condition can be used to control the visual attributes of cells with date/time values which fall within a range of time as specified by the DateTimeConditionalFormat.dateOperator property.
This condition provides only limited support for defining date/time ranges, i.e., the current, previous, or next day, week or month. For wider ranges, or more precise conditions, use the FormulaConditionalFormat class, and assign the desired date/time formula to the FormulaConditionalFormat.formula property.
Dependencies
-
dateOperator
- .dateOperator( );
- Return Type:
- ig.excel.FormatConditionTimePeriod
- Return Type Description:
- Returns a FormatConditionTimePeriod.
Returns a FormatConditionTimePeriod value which defines the range of time against which cell values are compared when evaluating this condition.
See Also
-
dateOperator
- .dateOperator( value:ig.excel.FormatConditionTimePeriod );
- Return Type:
- ig.excel.FormatConditionTimePeriod
- Return Type Description:
- Returns a FormatConditionTimePeriod.
Sets a FormatConditionTimePeriod value which defines the range of time against which cell values are compared when evaluating this condition.
- value
- Type:ig.excel.FormatConditionTimePeriod
See Also