wcellsel

Brief Information

Select cell(s) with specified condition

1. wcellsel rng:=1! cond:=le val:=3; // whole sheet to select all cells < 3

2. wcellsel rng:=1 c:=gt v:=0.5; // sel col(1) for cells > 0.5

3. wcellsel c:=none; // clear all selection in active sheet

4. wcellsel;// same as above since none is the default

Display Name	Variable Name	I/O and Type	Default Value	Description
Input	rng	Input/Output Range	<active>	The specified range to select.
Condition	condition	Input int	none	The condition to select data Option list: eq:RefCol[ii] = Equal to the specified Cutoff data lt:RefCol[ii] < less than the cutoff data le:RefCol[ii] <= No more than the cutoff data gt:RefCol[ii] > more than the cutoff data ge:RefCol[ii] >= No less than the cutoff data ne:RefCol[ii] <> Not equal to the cutoff data none:Clear All
Cutoff Value	val	Input double	0.05	The cutoff data is used for condition.
Tolerance for Equal Testing	tol	Input double	1E-6	Tolerance used in comparing the values of the cell and the cutoff.

This function is used to set cell(s) color with specified condition.