Required Argument

expression

is an expression that is evaluated for each cell. If expression resolves to TRUE (a nonzero value), the style element that is specified is used for the current cell. If expression is FALSE (zero), the next expression in the statement is evaluated. Thus, you can string multiple expressions together to format cells conditionally.

expression has this form:

expression-1 <comparison-operator expression-n>

expression

is an arithmetic or logical expression that consists of a sequence of operators and operands. An operator is a symbol that requests a comparison, logical operation, or arithmetic calculation. An operand is one of the following:

1

is a fixed value that you can use to set a constant style element.

Example:These statements set the cellvalue Frequency background to gray:

define cellvalue Frequency;
other–statements ...;   
cellstyle 1 as {backgroundcolor=gray}; 
end;

_VAL_

is the value of the current cell.

Example:The following statements change the foreground color of the cellvalue Percent depending on its magnitude:

define cellvalue Percent;    
other–statements ...;    
cellstyle _val_ > 75.00 as {color=red}, 
_val_ > 50.00 as {color=orange}, _val_ > 25.00 as {color=green}; 
end;

comparison-operator

compares a variable with a value or with another variable.

Comparison Operators

Symbol	Mnemonic Equivalent	Definition
=	EQ	Equal to
^= or ~= or ¬= or <>	NE	Not equal to
>	GT	Greater than
<	LT	Less than
>=	GE	Greater than or equal to
<=	LE	Less than or equal to
	IN	Equal to one from a list of values

Tip:Using an expression of 1 as the last expression in the CELLSTYLE AS statement sets the style element for any cells that did not meet an earlier condition.