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. The Expression property specifies a formula that indicates the criteria to format the items or the columns. Use the ApplyTo property to specify when the items or the columns are  formatted. Use the Add method to specify the expression at adding time. The Expression property may include variables, constants, operators or ( ) parenthesis.  A variable is defined as %n, where n is the index of the column ( zero based ). For instance, the %0 indicates the first column, the %1, indicates the second column, and so on.  A constant is a float expression ( for instance, 23.45 ). Use the Valid property checks whether the expression is syntactically correct, and can be evaluated. If the expression contains a variable that is not known, 0 value is used instead. For instance, if your control has 2 columns, and the expression looks like "%2 +%1 ", the %2 does not exist, 0 is used instead. When the control contains two columns the known variables are %0 and %1. 

The Expression property supports the following binary arithmetic operators:

• * ( multiplicity operator ), priority 5
• / ( divide operator ), priority 5
• + ( addition operator ), priority 4
• - ( subtraction operator ), priority 4

The Expression property supports the following unary boolean operators:

• not ( not operator ), priority 3 ( high priority )

The Expression property supports the following binary boolean operators:

• or ( or operator ), priority 2
• and ( or operator ), priority 1

The Expression property supports the following binary boolean operators, all these with the same priority 0 :

• < ( less operator )
• <= ( less or equal operator )
• = ( equal operator )
• != ( not equal operator )
• >= ( greater or equal operator )
• > ( greater operator )

Obviously, the priority of the operations inside the expression is determined by ( ) parenthesis and the priority for each operator. The Expression property may be a combination of variables, constants and operators. 

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

• Bold property. Bolds the cell or items
• Italic property. Indicates whether the cells or items should appear in italic.
• StrikeOut property. Indicates whether the cells or items should appear in strikeout.
• Underline property. Underlines the cells or items
• Font property. Changes the font for cells or items.
• BackColor property. Changes the background color for cells or items, supports skins as well.
• ForeColor property. Changes the foreground color for cells or items.

Samples:

1. "1", highlights all cells or items. Use this form, when you need to highlight all cells or items in the column or control. 
2. "%0 >= 0", highlights the cells or items, when the cells in the first column have the value greater or equal with zero
3. "%0 = 1 and %1 = 0", highlights the cells or items, when the cells in the first column have the value equal with 0, and the cells in the second column have the value equal with 0 
4. "%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
5. "%0+%1 > %2+%3", highlights the cells or items, when the sum between first two columns is greater than the sum between third and forth column.
6. "%0+%1 >= 0 and (%2+%3)/2 < %4-5", highlights the cells or the items, when the sum between first two columns is greater than 0 and the half of the sum between third and forth columns is less than fifth column minus 5.

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_gantt.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.

 

---

Send comments on this topic.

© 1999-2006 Exontrol Inc, Software. All rights reserved.