Please note that this control has been retired and is now obsolete to the XamDataGrid control, and as such, we recommend migrating to that control. It will not be receiving any new features, bug fixes, or support going forward. For help or questions on migrating your codebase to the XamDataGrid, please contact support.
There are several types of conditions that you can build. Some of these conditions use simple operators like LessThan or GreaterThan. Other conditions allow you to build complex formulas to meet your application’s individual needs.
The following lists the different types of conditions.
Numeric Rules
The numeric rules give you a simple way to perform common comparisons between two values. These rules determine the final cell style.
There are five different types of numeric rules.
AverageValueConditionalFormatRule - This rule highlights the cells where their value is equal to the average value of the column.
DataBarConditionalFormatRule - This rule inserts a bar indicating the cell value relative to other cells in the column. The rule allows the minimum / maximum range values to be specified. Using this rule, you can configure the bar appearance, the fill color, the border style and the border color. You can also configure the direction of the bar, Left-to-Right or Right-to-Left. You can also remove the value from the cells, so that only the bar is visible in the cell. If a cell value contains a negative value, you can change the appearance for the bar. Also, you can display an axis at the cell midpoint.
IconConditionalFormatRule - This rule inserts an icon indicating the cells value relative to other cells in the column. The rule allows for a series of images to be defined, where each image is associated with a specific sub-range of values within the larger total range value.
ThreeColorScaleConditionalFormatRule - This rule creates a three color gradient based on the range of the column values. The rule allows for a minimum / midpoint / maximum range values to be specified.
TwoColorScaleConditionalFormatRule - This rule creates a two color gradient based on the range of the column values. The rule allows the minimum/maximum range values to be specified.
Boolean Rules
Boolean rules are rules that when they are evaluated against an individual cell they result in a Boolean True / False result. Boolean rules apply the same predetermined style to each cell that matched the rule condition. Boolean rules can be configured so that if a rule results in a True value, further rules processing is stopped.
Input values for Boolean rules are:
Cell Value
Text String
Date
The following rules take a cell value:
BetweenXandYConditionalFormatRule - This rule determines the cells where the values are between certain values.
EqualToConditionalFormatRule - This rule determines the cells where the values are equal to a certain value.
GreaterThanConditionalFormatRule - This rule determines the cells where the values are greater than a certain value.
GreaterThanOrEqualToConditionalFormatRule - This rule determines the cells where the values are greater than or equal to a certain value.
LessThanConditionalFormatRule - This rule determines the cells where the values are less than a certain value.
LessThanOrEqualToConditionalFormatRule - This rule determines the cells where the values are less than or equal to a certain value.
MaximumValueConditionalFormatRule - This rule determines if a cell’s value is the maximum value in the column.
MinimumValueConditionalFormatRule - This rule determines if a cell’s value is the minimum value in the column.
NotBetweenXandYConditionalFormatRule - This rule determines the cells where the values are not between certain values.
NotEqualToConditionalFormatRule - This rule determines the cells where the value is not equal to a certain value.
The following rules take a text string:
BeginningWithConditionalFormatRule - This rule determines the cells where their values begin with the substring defined by the rule.
ContainingConditionalFormatRule - This rule determines if the cell value contains a particular string.
EndingWithConditionalFormatRule - This rule determines the cells where their values end with the substring defined by the rule.
NotContainingConditionalFormatRule - This rule determines if the cell value does not contain a particular string.
Related Topic