hello,
i have a data in range A6:B500
I want to highlight duplicate with one color only but highlight every second dup
thanx
Capture.JPG
hello,
i have a data in range A6:B500
I want to highlight duplicate with one color only but highlight every second dup
thanx
Capture.JPG
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Hi Haroon,
See if the attached file helps you. The logic is, finding the number of occurrences of a particular value and use conditional formatting.
Thanks
Elayaz
Hello HaroonSid,
This macro will leave only the duplicates visible on the worksheet. The first group will be yellow, the second group white, the third group will be yellow and the fourth group white, etc. All unique rows will be hidden.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you leith Ross
its working perfectly
and elayaz you too
actually i need macro so i will use macro instead of conditional formatting
Hello HaroonSid,
You're welcome. Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks