Hi Guys,
I have this code that highlights cells with the same values regardless of being contiguous or non-contiguous in one column. Can this code be modified to highlight ONLY contiguous cells in one column with the same values? Other non-contiguous cells with the same values should be ignored.
Appreciating any valuable input. Thanks in advance.
Please Login or Register to view this content.
this seems to work but not sure how you want to treat multiple contingent groups. ie if the number 1 is grouped in a set of 5 then a set of 1 then a set of 2 this will highlight the group of 5 AND the group of 2 but not the group of 1
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
Thank you mate for your promptness and genius code. It ran very smoothly and did as exactly as it is needed for. My best personal regards.
No problems mate. Thanks for the rep too.
HI Crooza, running the code for a while, I noticed it skips many duplicate values in the same column without highlighting, any suggestions? thanks.
Sorry mate, it was my mistake. Because I changed the colour palette some duplicates were actually highlighted but in "no colour". So please disregard my previous comment. Once again, thank you very much.
Phew. I was wracking my brain trying to work this out. Glad it's all working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks