Changing the appearance of a cell based on its value used to be a tedious task, as you had to test each value during the InitializeRow event. This code had to be highly customized and was very time-consuming. We now offer a more timely and efficient way of conditionally formatting different cells in a column.
Using our new conditional formatting feature, you can create conditional statements easily in simple dialog boxes. All you need to do is create a new OperatorCondition and link it to a ValueBasedAppearance property of any column. Once the ValueBasedAppearance property is set, the column will use the OperatorCondition to test all values of cells in the column against whatever condition you supply.
You can even use multiple conditional statements by adding several OperatorConditions to a ConditionGroup . You can choose to have the appearance applied if all conditions are met, or only one condition is met.