2.2.3.44 wcoloroutlier

Menu Information

Worksheet: Conditional Formatting: Outlier

Assign colors to outliers like Box chart.

1. wcoloroutlier rng:=[Book1]Sheet1!A:D name:="C1R1-C4R0";

2. wcolortb rng:=[Book1]Sheet1!A:B name:="C1R1-C2R0" tr.fill:=31306751 tr.font:=32497615;

3. wcolortb rng:=[Book1]1!A:E name:="C2R1-C5R0" rule:=1 coef:=3;

Please refer to this page for additional option switches when accessing the x-function from script.

Display Name	Variable Name	I/O and Type	Default Value	Description
Range	rng	Input Range	<active>	Specify range of the cells in the worksheet to apply conditional formatting. Note: to applly the conditional formatting to a set of text values, please set this column as categorical first (right click on this column and select Set as Categorical).
Name	name	Input String		Specify the name for the selected range.
Rule	rule	Input int	0	Specify the rule to determine the outliers. Options: iqr:IQR(0) Same as Whisker Range = Outlier in Box chart. sd:SD(1) Same as Whisker Range = SD in Box chart.
Coef	coef	Input Double	1.5	Select or type a value n to expand the whisker by the factor of n.
Format	tr	Input TreeNode	<unassigned>	Color settings. See details in the table below.