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.
Input
Range
string
int
Use this X-Function to color cells with duplicate value.
wcolor, wheatmap
Keywords:cell coloring, formatting