Highlighting duplicates

SubBow

New Member
Joined
May 28, 2010
Messages
8
Hi,
I'm looking to highlight duplicates where only 2 rows are duplicated. In the below example, I only want the first and third results highlighted, not the second result in the first column, too, which is how excel will highlight it if I use conditional formatting
cup8 oz.
cup16 oz.
cup8 oz.
plate12"
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Screenshot 2024-10-31 184257.png


Book1
ABCD
1cup8=COUNTIFS($A$1:$A$5,$A1,$B$1:$B$5,$B1)>1
2cup16
3cup8
4abc1
5xyz2
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A1:B5Expression=COUNTIFS($A$1:$A$5,$A1,$B$1:$B$5,$B1)>1textNO
 
Upvote 0
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You could try Conditional Formatting like this.

24 10 31.xlsm
AB
1
2cup8 oz.
3cup16 oz.
4cup8 oz.
5plate12"
Dupes
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:B5Expression=COUNTIFS($A$2:$A$5,$A2,$B$2:$B$5,$B2)>1textNO
 
Upvote 0

Forum statistics

Threads
1,224,815
Messages
6,181,136
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top