

| Type | Description | |||
| FormatApplyToEnum | A FormatApplyToEnum expression that indicates whether the format is applied to items or to columns. If the ApplyTo property is less than zero, the format is applied to the items. |
The following VB sample bolds 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 ComboBox1.ConditionalFormats.Add("%1+%2<%0")
.ApplyTo = 1
.Bold = True
End With The following C++ sample bolds 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_combobox.GetConditionalFormats().Add( "%1+%2<%0", vtEmpty ); cf.SetBold( TRUE ); cf.SetApplyTo( 1 );
The following VB.NET sample bolds 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 AxComboBox1.ConditionalFormats.Add("%1+%2<%0")
.ApplyTo = 1
.Bold = True
End With The following C# sample bolds 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 ):
EXCOMBOBOXLib.ConditionalFormat cf = axComboBox1.ConditionalFormats.Add("%1+%2<%0",null);
cf.Bold = true;
cf.ApplyTo = (EXCOMBOBOXLib.FormatApplyToEnum)1; The following VFP sample bolds 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.ComboBox1.ConditionalFormats.Add("%1+%2<%0")
.Bold = .t.
.ApplyTo = 1
endwith