|
»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 may 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.
