Conditional Formatting for Multiple Criteria

[davidcox9]

Hello,

I am trying to find if there are duplicates in my sheet. I need to know if the receipt date (H), quantity (D) and description (C) are duplicated but I can not get anything to work properly below is a screenshot so you can better understand.

 

[awoohaw]

try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	60	67	53	62	10	70	86	89	45	19		TRUE
3	62	30	11	45	69	53	73	72	47	22		FALSE
4	60	74	78	74	69	86	82	69	48	12		FALSE
5	43	18	61	82	30	56	51	80	29	65		FALSE
6	61	84	13	50	80	65	41	48	34	66		FALSE
7	42	33	53	62	29	43	80	89	49	51		TRUE
8	82	19	81	54	39	53	11	23	76	11		FALSE
9	63	33	26	35	36	86	14	72	50	14		FALSE
10	41	29	53	62	51	51	77	89	59	37		TRUE
11	66	89	79	83	25	22	68	57	27	31		FALSE
12
13
Sheet8

Cell Formulas
Range	Formula
L2:L11	L2	=COUNTIFS($C$2:$C$11,$C2,$D$2:$D$11,$D2,$H$2:$H$11,$H2)>1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:J11	Expression	=COUNTIFS($C$2:$C$11,$C2,$D$2:$D$11,$D2,$H$2:$H$11,$H2)>1	text	NO