2.2.3.42 wcolordup

Menu Information

Worksheet: Conditional Formatting: Duplicate

Mark duplicate entries with a range of worksheet cells.

1. wcolordup rng:=[Book1]Sheet1! name:="C1R1-C0R0" fill:=32167617 font:=26830387;

2. wcolordup rng:=[Book1]Sheet1!4[1]:7[11] name:="C4R1-C7R11" fill:=color(LT Yellow) font:=color(Orange);

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.
Name	name	Input string	<unassigned>	Specify the name for the selected range.
Apply Coloring to Sheet	extend	Input int	0	Specify whether to color the whole sheet range by the specifed condition. If selected, the applied color will extend from the input range to the whole row.
Background	fill	Input int	32167617	Specify the background color to mark the duplicated cells. Specify the color by internal color code or color() function with color name/ RGB triplet/ HTML hex color code.
Text Color	font	Input int	26830387	Specify the color to mark the text in the duplicated cells. Specify the color by internal color code or color() function with color name/ RGB triplet/ HTML hex color code.