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.