2.2.3.45 wcolorPareto


Contents

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.

Related X-Functions

wcolor, wcolordup, wheatmap, wcolorbycr, wcolortb, wcoloroutlier

Keywords:cell coloring