I am trying to find duplicates in a column and change the font color
The column is text formatted
some cells have one number others have multiple numbers separated with a comma and space
can anyone help in writing a macro to do this ?
example below
Thanks
|2 |
|13 |
|2 |
|10, 11, 13 |
|2, 4, 5, 9 |
|10 |
|8 |
The column is text formatted
some cells have one number others have multiple numbers separated with a comma and space
can anyone help in writing a macro to do this ?
example below
Thanks
|2 |
|13 |
|2 |
|10, 11, 13 |
|2, 4, 5, 9 |
|10 |
|8 |