Hi There,
I would like to Highlight duplicates in two columns using Conditional Formatting. My report has one column for "Parts" and "Country" in the next , I want excel to find the duplicate of this combination. I've attached a sample report with an example (in yellow) of result that is expected.
Thanks
use formula
Formula:
Please Login or Register to view this content.
applies to range
=$B$2:$C$8
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This is good but somehow this is slowing down my report which has 10 columns & around 1200 rows.
Then restrict the cell range. For example:
=COUNTIFS($B$2:$B$2000,$B2,$C$2:$C$2000,$C2)>1
is about 20x faster than using a whole column reference.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Yes this works faster!
Due to a new format today, 3 new columns are added between B & C. i.e column C is now F. I tried amending your formula to match the new column but this does not help.
Which columns do you want to be formatted?
B & F should be formatted.
here it is on a sheet.
Incidentally, why were you using the outdated .xls format (Excel 2003 and earlier) - when you have Excel 2013?
Hmm, I just saved it as it was a dummy file.
This works perfectly. Thanks for the help!
You're welcome!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks