Help WPS DUPLICATE

[Trident_muh]

What formula should I use to highlight duplicate in a separate sheet using conditional formating

 

[🤖]

To highlight duplicates in a separate sheet using conditional formatting in WPS, follow these steps:

1. Open the target sheet where you want to highlight duplicates.
2. Select the range of cells where you want to apply the conditional formatting.
3. Go to "Home" > "Conditional Formatting" > "New Rule".
4. In the "New Formatting Rule" dialog box, select the "Use a formula to determine which cells to format" option.
5. In the "Format values where this formula is true" box, you will need to input a formula.

The formula to identify duplicates from another sheet would be something like:

=COUNTIF(Sheet1!$A$1:$A$100, A1)>1

This formula checks if the value in cell A1 of the current sheet is found more than once in the range A1:A100 on Sheet1. Adjust the range and cell references to match your data.

6. Click on the "Format" button to specify how you want to highlight duplicates (e.g., fill color, font color, etc.), then click "OK".
7. Click "OK" again to close the "New Formatting Rule" dialog box.

Now, duplicates from the mentioned range in Sheet1 will be highlighted in the specified format on the current sheet.