2.2.3.42 wcolordup


Menu Information

Worksheet: Conditional Formatting: Duplicate

Brief Information

Mark duplicate entries with a range of worksheet cells.

Command Line Usage

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

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

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

Description

Use this X-Function to color cells with duplicate value.

Related X-Functions

wcolor, wheatmap


Keywords:cell coloring, formatting