DateTimeConditionalFormat Class

Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's date/time value falls within a given range of time.

Syntax

Visual Basic

'Declaration
 
Public NotInheritable Class DateTimeConditionalFormat 
   Inherits ConditionalFormatBase

C#

public sealed class DateTimeConditionalFormat : ConditionalFormatBase 

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 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.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2