Display duplicates
fbinice
-
yclik Posted messages 3874 Registration date Status Member Last intervention -
yclik Posted messages 3874 Registration date Status Member Last intervention -
Hello,
I'm starting with OpenOffice Calc.
I have a list of contacts (about 500) where I enter, for example, the phone number in one column.
I want to avoid duplicates, so I would like when I enter a new number, if it is already present elsewhere, it is highlighted in red (or something else...).
I looked at some tutorials on conditional formatting but nothing is happening on my side.
Anyway, I need help.
My current approach:
- I select the column
- Format > Conditional Formatting
- Formula is
- COUNTIF($A$1:$A$10; A1)>1 (found in a tutorial)
- New Style (I name it "duplicates" and then Background "red") and OK
=> nothing happens.
I'm starting with OpenOffice Calc.
I have a list of contacts (about 500) where I enter, for example, the phone number in one column.
I want to avoid duplicates, so I would like when I enter a new number, if it is already present elsewhere, it is highlighted in red (or something else...).
I looked at some tutorials on conditional formatting but nothing is happening on my side.
Anyway, I need help.
My current approach:
- I select the column
- Format > Conditional Formatting
- Formula is
- COUNTIF($A$1:$A$10; A1)>1 (found in a tutorial)
- New Style (I name it "duplicates" and then Background "red") and OK
=> nothing happens.
1 answer
-
Hello
To apply conditional formatting to all cells:
Select the cells from bottom to top and create the conditional formatting (the active cell is the last selected cell and the relative addressing depends on this)
or
Create the conditional formatting on the first cell and replicate it with the paintbrush
Double click on the paintbrush tool (apply format)
Select all the relevant cells
Esc
