LinkBack URL
About LinkBacks
I ve got this code.
Hey,
Please Login or Register to view this content.
I want to highlight the first unique values in red and the duplicates of it in bold. Currently I highlight all duplicates. What should I change? Thanks
I ve got this code.
Hey,Please Login or Register to view this content.
I want to highlight the first unique values in red and the duplicates of it in bold. Currently I highlight all duplicates. What should I change? Thanks
Last edited by arlu1201; 03-05-2013 at 05:25 AM. Reason: Code tags not php tags.
Please add code tags
any ideas?
You want this to happen in columns B to E or only one specific column?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I ve got a table which starts from B5 do E30. So the respective columns in the table are the columns from B to E.
Will it always be one pair of duplicates or are there chances of having more than 1 duplicates?
Maybe you can attach a sample sheet to make it clear.
There is a chance of having more than one duplicate. I want the first value to be colored in red and the duplicates (no matter how many) should be in bold. That's it. The code I ve got colors all duplicates.
Do you have a sample file that you can upload?
Unfortunately, currently that's not possible. Its not that difficult , though, to visualize what I want and create a simple database to test..
I can do that, with no issues.
But sometimes it happens that the code i provide works on my file but not on yours.
Anyways, i will provide the code here shortly. Try it and let me know.
Sure, thanks a lot!
Try this code
Please Login or Register to view this content.
Hi dulitu19,
Post back re how this goes:
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks