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 may be a combination of variables, constants, strings, dates and operators. A string is delimited by ", ` or ' characters, and inside they can have the starting character preceded by \ character, ie "\"This is a quote\"". A date is delimited by two # characters, ie #1/31/2001 10:00# means the January 31th, 2001, 10:00 AM.
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:
Tree1.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:
AxTree1.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:
axTree1.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.Tree1.ConditionalFormats.Add("%0+%1>0").Bold = .t.