2.2.3.42 wcolorbycr


Contents

Menu Information

Worksheet: Conditional Formatting: Highlight Min Max: Row-wise/Column-wise

Brief Information

Assign colors to the maximum/minimum values by row or by column.

Command Line Usage

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

2. wcolorbycr rng:=[Book1]Sheet1!A:B name:="C1R1-C2R0" max.fill:=31306751 max.font:=32497615;

3. wcolorbycr rng:=[Book1]2!A:B name:="C1R1-C2R0" dir:=1 min.fill:=31306751 min.font:=32497615;;

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. Note that only numeric cell is supported.
Name name

Input

string

Specify the name for the selected range.
Direction dir

Input

int

0 Radio button to color maximum and/or minimum value by row-wise or by column-wise. Options:
  • row:Row-wise(0)
  • col:Column-wise(1)
Maximum max

Input

TreeNode

<unassigned> Color settings for the maximum value cell. See details in the table below.
Minimum min

Input

TreeNode

<unassigned> Color settings for the mimimum value cell. See details in the table below.

TreeNode Details

max

Syntax: max.treenode=value

Display
Name 		Treenode
Name 		I/O
and
Type 		Default
Value 		Description
Background fill

Input

Double

30067455 Specify the filled color of Maximum cell
Text Color font

Input

Double

20132812 Specify the font color of Maximum value.



min

Syntax: min.treenode=value

Display
Name 		Treenode
Name 		I/O
and
Type 		Default
Value 		Description
Background fill

Input

Double

33085116 Specify the filled color of Minimum cell
Text Color font

Input

Double

26692113 Specify the font color of Minimum value.

Description

Color minimumn and/or maximum values in each selected colulmn/row, independent of other columns or rows. See for details on this document.

Related X-Functions

wcolor, wcolordup, wheatmap, wcolorPareto, wcolortb

Keywords:cell coloring