Type | Description | |||
Boolean | A boolean expression that indicates whether the objects should look in italic. |
With Group1.ConditionalFormats.Add("%1+%2<%0") .ApplyTo = 1 .Italic = True End With
The following C++ sample makes italic the cells in the second column ( 1 ), if the sum between second and third column ( 2 ) is less than the value in the first column ( 0 ):
COleVariant vtEmpty; CConditionalFormat cf = m_group.GetConditionalFormats().Add( "%1+%2<%0", vtEmpty ); cf.SetItalic( TRUE ); cf.SetApplyTo( 1 );
The following VB.NET sample makes italic the cells in the second column ( 1 ), if the sum between second and third column ( 2 ) is less than the value in the first column ( 0 ):
With AxGroup1.ConditionalFormats.Add("%1+%2<%0") .ApplyTo = 1 .Italic = True End With
The following C# sample makes italic the cells in the second column ( 1 ), if the sum between second and third column ( 2 ) is less than the value in the first column ( 0 ):
EXPLORERTREELib.ConditionalFormat cf = axGroup1.ConditionalFormats.Add("%1+%2<%0",null); cf.Italic = true; cf.ApplyTo = (EXPLORERTREELib.FormatApplyToEnum)1;
The following VFP sample makes italic the cells in the second column ( 1 ), if the sum between second and third column ( 2 ) is less than the value in the first column ( 0 ):
with thisform.Group1.ConditionalFormats.Add("%1+%2<%0") .Italic = .t. .ApplyTo = 1 endwith