property Gantt.ConditionalFormats as ConditionalFormats
Retrieves the conditional formatting collection.

 TypeDescription 
   ConditionalFormats A ConditionalFormats object that indicates the control's ConditionalFormats collection.  
The conditional formatting feature allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. Use the Add method to format cells or items based on a formula. Use the Refresh method to refresh the control, if a change occurs in the conditional format collection. Use the CellCaption property indicates the cell's caption or value.

The conditional format feature may change the cells and items as follows:

The conditional format feature may change the bars as follows:

The ApplyTo property specifies whether the ConditionalFormat object is applied to items or to a column. Use the ApplyToBars property to specify the list of bars that the current format is applied to.

The following screen shot shows different colors applied to different items, using the ConditionalFormat feature:

 


Send comments on this topic.
1999-2018 Exontrol.COM, Software. All rights reserved.