OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                           
 

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

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

Input

int

32167617 Specify the background color to mark duplicate the worksheet 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 text color to mark duplicate the worksheet 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

X-Function:wcolor, X-Function:wheatmap


Keywords:cell coloring, formatting

 

© OriginLab Corporation. All rights reserved.