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