I have a column with values such as 00Q7000000JqHbA and 00Q7000000JqHba that are separate entries. When I go to Conditional Formatting > Highlight Cells Rules > Duplicate Values, these values get marked as duplicates when they're not for my purposes. Is there a way to make the filter case sensitive?
For example, the two entries "BLUE" and "BLUE" would be marked as duplicates, but the entries "RED" and "red" would not.
Not sure about Excel2007 Conditional Formattting... but you can perhaps just use a formula....
e.g.
Select entire range, say H1:H100 and invoke Conditional Formatting....
Formula Is >> =AND(H1<>"",SUMPRODUCT(--(EXACT(H1,$H$1:$H$100)))>1)
where H1 is top most cell in your selected range
Select your format.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you very much for the help. Your idea worked perfectly.
How do you work the same if the data is in two different tabs?
Hi, welcome to the forumOriginally Posted by Madhuri Jaikumar
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks