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:
|
| N | n |
Input Double |
10 | Specify number N in the Rule. |
| 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 the largest/smallest N values in the selected range. See for details on this document.
wcolor, wcolordup, wheatmap, wcolorPareto, wcolorbycr, wcoloroutlier
Keywords:cell coloring