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:
|
| 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. |
Syntax: tr.treenode=value
| Display Name |
Treenode Name |
I/O and Type |
Default Value |
Description |
|---|---|---|---|---|
| Background | fill |
Input Double |
30067455 | Specify the filled color of the worksheet cells |
| Text Color | font |
Input Double |
20132812 | Specify the font color of the values. |
Color outliers in the selected Range like Box chart. See for details on this document.
wcolor, wcolordup, wheatmap, wcolorPareto, wcolorbycr
Keywords:cell coloring