highlight duplicate value comparing previous row only

[purelutz]

given data below is it possible to compare and highlight duplicate values from only the row directly below and not any other row. see example below. using the conditional formatting duplicate highlight will highlight any duplicates in given range. thanks.

 

[snjpverma]

Like this?

Select the upper left most cell and put the formula and then you can copy paste the format in other cells.

Book1
	G	H	I	J	K	L
10	36	41	50	12	27	9
11	36	29	48	2	38	45
12	10	4	35	38	43	6
13	45	16	14	25	10	25
14	19	4	14	36	42	27
15	48	50	34	42	42	42
16	21	33	3	11	11	7
17	33	16	33	45	27	11
18	27	6	9	31	19	16
19	9	26	48	31	49	26
20	13	12	45	2	13	9
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G10:L20	Expression	=G10=G9	text	NO

 

[purelutz]

that formula only highlights the duplicate if it is directly above. i want to highlight if it's anywhere in the row.

 

[snjpverma]

In that case you can use the match function

 

[sandy666]

maybe select whole range and from Conditional Formatting choose Highlight Cell Rules - Duplicate Values

or play with $ sign, eg. G$10=G9