I have a column with more than 10000 rows.
What I need to do is find unique value in each selection group and color in orange this group if there is unique value.
For example numbers 2 and 3 are different and these 2 rows need to color in orange as there are unique values in the group. If there are numbers 5 and 5 (duplicate) then need to color in green both numbers in that group and so on - macro compare values and color each group separately. If there is 17 25 26 3 3 where some numbers are unique and some are duplicate then also need to color in orange this group. If there is only one number in each group then do nothing and go to the next comparison group till all routine is done.
Sounds like very easy but I am really stuck and Google also is not on my side to help.
Sample I have added below.
1
2
3
4
1
5
5
6
7
7
8
9
9
10
10
11
5
4
9
8
12
13
14
15
16
3
17
18
18
12
19
20
7
6
12
21
12
5
18
19
5
5
22
17
17
23
23
7
20
24
17
25
26
3
3
27
28
Bookmarks