2.2.3.45 wcolorPareto

1 Menu Information
2 Brief Information
3 Command Line Usage
4 X-Function Execution Options
5 Variables
- 5.1 tr TreeNode Details
6 Description
7 Related X-Functions

Menu Information

Worksheet: Conditional Formatting: Pareto

Brief Information

Calculate count of selected worksheet cells, order them from top frequent to least frequent, and color the most/least frequent items.

Command Line Usage

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

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

3. wcolorPareto rng:=[Book1]Sheet1!A:B name:="C1R1-C2R0" rule:=2 n:=10;

X-Function Execution Options

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

Variables

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.
Name	name	Input string		Specify the name for the selected range.
Rule	rule	Input int	0	Determine which cells to be colored. Options: most:Most Frequent N Items(0) mostp:Most Frequent N%(1) least:Least Frequent N Items(2) leastp:Least Frequent N%(3)
N	n	Input Double	1	Specify the number of the most/least frequent items to be colored.
Format	tr	Input TreeNode	<unassigned>	Set the colors. See details in the table below.

tr TreeNode Details

Syntax: tr.treenode=value

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

Background

fill

Input

Double

30067455

Specify the filled color of worksheet cells

Text Color

font

Input

Double

20132812

Specify the font color .

Description

Calculate count of all items in the selected range, and order them from top frequent to least frequent like Pareto chart. An then color the most/least frequent N items.