|
»Spread for Windows Forms
» Product Tour
» Conditional Formatting
|
|
jump to:
|
|
Conditional Formatting |
|
You can set up conditional formats within cells that determine the formatting of the cell based on the outcome of a conditional statement.
You can use a named style to specify various formatting options such as borders and colors to apply if the condition statement is valid, that is, if the operation is satisfied.
For example, you might want to change the background color of a cell based on the value of the cell. If the value is below 100 then the background color would be changed to red. The condition statement is "less than 100" and consists of a comparison operator "less than" and a condition, in this case a single constant "100". The condition can be a constant (expressed as a string) or an expression.
Refer to the example below to see how conditional formatting can be set for a range of cells that would result in different background colors, for instance, depending on the value in the cell.
