2.2.3.42 wcolorbycr

Menu Information

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

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

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;;

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 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.