Hey Everyone,
I'm having a hard time finding a solution to finding duplicates based on the number of duplicates found. I know how to setup CF to find duplicates but what if I want to change the CF to highlight the cells depending on how many times they're duplicated. EXAMPLE: if a double match is found highlight Yellow, if a triple match is found highlight orange....etc. Hope this makes sense. I'm trying to create a 2,3,4, and 5 duplicate CF. Hoping this is possible.
PLEASE HELP! Thanks so much!
I'm having a hard time finding a solution to finding duplicates based on the number of duplicates found. I know how to setup CF to find duplicates but what if I want to change the CF to highlight the cells depending on how many times they're duplicated. EXAMPLE: if a double match is found highlight Yellow, if a triple match is found highlight orange....etc. Hope this makes sense. I'm trying to create a 2,3,4, and 5 duplicate CF. Hoping this is possible.
PLEASE HELP! Thanks so much!