Highlight duplicate cell values in a row with different color code

[picon1983]

Not even sure if it is possible:

There is a dynamic table (the range may increase or decrease by row or column.
Under each header, there are values.
Per row, if there are duplicate values, then the cells should be highlighted by different colors.

Example: Header 1 and 2 has A and A duplicate for row 2 (should be highlighted with one random color). Again, Header 4 and 5 have C as duplicate so the cells should be colored with a different color.
Image attached for suggestion.

Any color is fine as long as all the duplicates/triplicates are highlighted with similar sets of colors by row (NOT BY COLUMN).


Header1 Header2 Header3 Header4 Header5 Header6 Header7
A A B C C 1 1
V B C C 1 2 1
1 3 C D V 1 Q
123.jpg


Thanks a LOT in advance.

[PCI]

See how the macro can do the job
There is some limits: No more than 10 different duplicate
No more than 190 cells per row

Please Login or Register  to view this content.

[picon1983]

Dear PCI, you are a genius.
But there is a small problem.
For example, in row 4 (in attached image), for the "C"s, the call colorsDF.JPG should be same.

[PCI]

Are the values exactly the same ...
Can you copy and paste the value from B4 to others and see the result
Can you attach a short excel sample ?

[jindon]

Try

Please Login or Register  to view this content.

[PCI]

Yes there was a "bug" .. try next code

Please Login or Register  to view this content.

[picon1983]

Thank you PCI. Big help.

[picon1983]

Thank you jindon.