2.2.3.46 wcolortb

Menu Information

Worksheet: Conditional Formatting: Top/Bottom

Assign colors to top/bottom N values.

1. wcolortb 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;

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 of which values to be colored. Options: top:Top N Items(0) topp:Top N%(1) btm:Bottom N Items(2) btmp:Bottom N%(3)
N	n	Input Double	10	Specify number N in the Rule.
Format	tr	Input TreeNode	<unassigned>	Color settings. See details in the table below.