Hello. I am doing an internship in which we make use of Excel for a lot of different things. One of the things we do is entering values into an Excel sheet and then searching the values in another program to get more data specific to the value. This also includes duplicate values and if we manage to notice them, we can just copy and paste the previous data specific to the value without having to enter a value we have already queried into other program again. To make this more easy for me, I searched up ways to highlight/mark different duplicate values with different colours but unfortunately most methods I found were only limited to 3 distinct colours and we work with more unique sets if duplicates than 3. I thought assigning a variable to an RGB value that keeps increasing as more sets of duplicates are added but couldn’t manage to figure out how to implement it.
An example is uploaded
An example is uploaded
