Dutch_girl
New Member
- Joined
- Jul 6, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a column where I need to highlight duplicate numbers but only when they are not next to each other:
11
57
48
45
12<-- this should not be highlighted
12<-- this should not be highlighted
95
87
12<-- this should be highlighted
43
I'm filling in data regarding contracts and contract numbers. 1 contract can have multiple lines, but should only be in the file once. The multiple lines per contract can vary.
Can someone please help me?
11
57
48
45
12<-- this should not be highlighted
12<-- this should not be highlighted
95
87
12<-- this should be highlighted
43
I'm filling in data regarding contracts and contract numbers. 1 contract can have multiple lines, but should only be in the file once. The multiple lines per contract can vary.
Can someone please help me?