When working with a column of data, you may need to call attention to those items that are duplicated within the range. This article provides the steps to highlight duplicate entries in a range of data in Lotus Symphony 3.
This article assumes that you are generally familiar with conditional formatting of cells. If you would like additional information on this topic, including the steps to create a style to be used in the formatting, please see the following wiki article:
|Create a style to be used as the highlight for the duplicates. In this example, a style named Duplicates with a gold background is used.|
|Select the range of data where you want to highlight the duplicates. In this example, the list of city names in A1:A10 is selected.|
|From the menu, choose Layout > Cell Formatting Conditions.|
|In the Cell Formatting Conditions dialog box:|
- Enable Condition 1.
- Change Cell value is to Formula is.
- Enter a formula following this example - COUNTIF($A$1:$A10; $A10)>1 where $A$1:$A10 corresponds to your range of data and $A10 is the last cell in the range.
- Select your style from the list of Cell Styles.
|Now the entries that are duplicated in the range of data will be highlighted in gold as specified by the style. |
If a change is made to the style, the highlighted cells will automatically reflect those changes.