Formatting rows based on unique combinations

[MikeThePooh]

Hi all, I want to be able to format rows based on unique combinations of values across columns. So, just like this function:

Except, rather than this just identifying and formatting unique values in a single column, it would need to identify unique combinations of values across multiple columns. When I try to highlight multiple columns while using this tool, it still only highlights cells with unique values in each column.

For context, in case this isn't the best way to do what I'm trying to do: I'm trying to essentially do the opposite of Remove Duplicates, i.e., I want to do exactly this except removing unique values instead of duplicate values:

 

[awoohaw]

Welcome to the forum.
It would be more helpful is you shared a sample of data and an expected outcome. A Table would be good (but using the xl2bb add in - link below) would be best.
Do not post an image, as that means the forum needs to construct your scenario from nothing.

Thanks in advance.

 

[Eric W]

Try:

Book1
	F	G	H
1	Col A	Col B	Col C
2	a	1	dog
3	b	2	cat
4	c	3	mouse
5	d	1	iguana
6	e	2	bird
7	f	3	dog
8	g	1	cat
9	h	2	mouse
10	a	3	iguana
11	b	1	bird
12	c	2	dog
13	d	3	cat
14	e	1	mouse
15	f	2	iguana
16	g	3	bird
17	h	1	dog
18	a	2	cat
19	b	3	mouse
20	c	1	iguana
21	d	2	bird
22	e	1	mouse
23	f	1	cat
24	g	2	mouse
25	h	3	iguana
26	a	1	dog
27
Sheet17

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F:H	Expression	=COUNTIFS($F:$F,$F1,$G:$G,$G1,$H:$H,$H1)>1	text	NO

 

[MikeThePooh]

Ah okay, my mistake on the screenshots. Here's a data set in table form:

A	B	C	D
1	1	1	1
1	1	1	1
2	2	1	1
2	1	1	1
3	3	2	1
3	3	2	1
4	1	2	3
5	2	2	2
6	3	3	3
7	3	2	1

I would want some sort of tool that deletes rows 4-5, 8-11 and leaves rows 2-3, 6-7.

 

[MikeThePooh]

@Eric W , I got an error message when I tried this here. Not sure if I'm doing it wrong...

 

[MikeThePooh]

Oh wait, I see where I went astray with that formula! Disregard @Eric W , I think this worked. Thank you!!

 

[Eric W]

Glad we could help!