Hi, I'm looking for a way to highlight multiple occurrences of duplicate in different colour. I apologise for my phrasing as I am not a native english speaker. I am trying to do as shown in attached picture Screenshot 2019-11-22 at 7.32.36 PM.png
Hi, I'm looking for a way to highlight multiple occurrences of duplicate in different colour. I apologise for my phrasing as I am not a native english speaker. I am trying to do as shown in attached picture Screenshot 2019-11-22 at 7.32.36 PM.png
I do not know how many possible occurrences you expect. For few (10-15 max) is make sense with Conditional Formatting like below:
Capture.PNG
For each number here
set different colour.Please Login or Register to view this content.
For more I think solution with VBA make more sense.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks