FarPoint Technologies, Inc.

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. Some condition statements have two conditions and an operator: for instance, if the cell value is between 0 and 100, then change the background color. In this case, the comparison operator is "between" and the first condition is 0 and the last condition is 100. For a complete list of operations, refer to the ComparisonOperator enumeration.

Type a number in the highlighted box below. If the number is less than 20, the backcolor will turn red and forecolor yellow. If the number is greater than 40, the the backcolor will turn blue and forecolor light green.

	A	B	C	D
1
2
3


				

				'Define Conditions
				

				'row, column, NamedStyle, condition, value

				FpSpread1.Sheets(0).SetConditionalFormat(1, 1, ns, 
				FarPoint.Web.Spread.ComparisonOperator.LessThan, "20")

				

				FpSpread1.Sheets(0).SetConditionalFormat(1, 1, ns2, 
				FarPoint.Web.Spread.ComparisonOperator.GreaterThan, "40")

Have a question?