Type | Description | |||
String | A formal expression that indicates the formula being used in formatting. For instance, "%0+%1>%2", highlights the cells or the items, when the sum between first two columns is greater than the value in the third column |
The expression supports cell's identifiers as follows:
This property/method supports predefined constants and operators/functions as described here.
Samples:
The conditional format feature may change the cells and items as follows:
The following VB samples bolds all items when the sum between first two columns is greater than 0:
Gantt1.ConditionalFormats.Add("%0+%1>0").Bold = True
The following C++ sample bolds all items when the sum between first two columns is greater than 0:
COleVariant vtEmpty; m_tree.GetConditionalFormats().Add( "%0+%1>0", vtEmpty ).SetBold( TRUE );
The following VB.NET sample bolds all items when the sum between first two columns is greater than 0:
AxGantt1.ConditionalFormats.Add("%0+%1>0").Bold = True
The following C# sample bolds all items when the sum between first two columns is greater than 0:
axGantt1.ConditionalFormats.Add("%0+%1>0", null).Bold = true
The following VFP sample bolds all items when the sum between first two columns is greater than 0:
thisform.Gantt1.ConditionalFormats.Add("%0+%1>0").Bold = .t.